You convert a PDF to Excel, the figures look right, and then you type a quick =SUM() at the bottom of a column and it returns 0. Or you select the column and Excel shows a count but no sum and no average. Often a little green triangle sits in the corner of each cell with a warning that the number is stored as text. The data is all there, it just is not behaving like numbers, so nothing you build on top of it works.
This is one of the most common snags in PDF to Excel work, and it is fixable in seconds once you know what causes it. Below is why your numbers come through as text, why Excel says it cannot detect them, and the quickest ways to turn them back into real numbers. The converter at the top of this page writes numeric cells directly, so try your file first, then use the fixes for anything Excel still flags.
Why do my numbers come through as text when I convert a PDF to Excel?
They come through as text because a PDF does not store numbers as numbers. It stores each figure as characters placed at a spot on the page, often with a currency symbol, a comma, a trailing space, or parentheses around a negative. When a converter or a copy-paste drops those characters into Excel, Excel sees a string that contains non-numeric characters and keeps it as text rather than guessing it is a quantity. The value is correct, but its type is wrong.
A few specific culprits show up again and again: a leading or trailing space, a non-breaking space used as a thousands separator, a currency symbol stuck to the digits, or a minus sign that is really a dash character. Any one of these is enough for Excel to refuse to treat the cell as a number.
Why does Excel say the numbers in my cells cannot be detected?
That message means Excel scanned the cells and found text where it expected numeric values, so the feature you tried to use, like a sum, a chart, or a pivot, has nothing numeric to work with. It is not saying the data is missing. It is saying every entry is formatted as text, so the tool cannot do math on it. You will see the same thing if the column is left-aligned: real numbers default to right alignment, and text defaults to the left, which is the quickest visual tell.
So the fix is never to retype the data. It is to change the type of the existing values from text to number, which Excel can do for a whole column at once.
How do I convert text to numbers in Excel after a PDF conversion?
Pick whichever of these fits the size of the problem:
- Convert to Number from the warning. Select the cells, click the yellow warning icon that appears, and choose Convert to Number. This is instant for a column or two and handles the most common case.
- Paste Special, Multiply. Type the number 1 in an empty cell and copy it. Select your text-numbers, then Paste Special and choose Multiply. Multiplying by 1 forces Excel to evaluate each string as a number. This clears stubborn cases the warning icon misses.
- Text to Columns. Select the column, go to Data, Text to Columns, and click Finish without changing anything. Excel re-parses each value and reassigns the type. Good for one column at a time.
- The VALUE function. In a helper column, use
=VALUE(A2)to return the numeric version, then paste the result back as values. Useful when you also want to strip stray characters with TRIM and SUBSTITUTE in the same step.
After any of these, click a cell and check that the number now sits right-aligned and that a test =SUM() returns a real total.
Why does SUM return 0 after converting a PDF to Excel?
SUM returns 0 because it ignores text. When every value in the range is stored as text, there is nothing for SUM to add, so it reports zero rather than an error. This catches people out because the cells clearly show numbers, but Excel is reading them as labels. The moment you convert the column to real numbers using any method above, the same SUM formula returns the correct total without you touching the formula.
If only part of the column is text, SUM will add the real numbers and silently skip the text ones, which gives you a total that looks plausible but is too low. That partial case is the dangerous one, so it is worth converting the whole column to be sure every row counts.
How do I stop numbers from importing as text in the first place?
The reliable answer is to use a converter that writes the numbers as numeric cells, so you skip the cleanup entirely. A tool that reads the real table structure and types each cell will hand you a sheet where amounts are already right-aligned and ready to total. That is the difference between an accurate PDF to Excel converter and a tool that simply dumps the page text into cells.
If you are importing a CSV by hand, you can also control the type during import: open Excel first, go to Data, From Text/CSV, and set the relevant columns to a number type in the preview instead of double-clicking the file open. But the simplest path is to get a clean spreadsheet out of the conversion itself rather than fixing types afterward.
Does converting to XLSX instead of CSV keep numbers numeric?
It can, because a native XLSX file stores a type for every cell, while a CSV is plain text with no type information at all. When a converter writes a proper PDF to XLSX file, it can mark the amount cells as numbers so they arrive ready to calculate. A CSV has no way to say this cell is a number, so Excel guesses on open, which is exactly when the text problem creeps back in.
That makes XLSX the safer target when your next step is math, formulas, or a pivot. Choose CSV only when another program will read the file and expects plain text, and in that case set the types in whatever system imports it.
How do I tell if a number is stored as text in Excel?
The fastest check is alignment: real numbers right-align by default and text left-aligns, so a column of left-aligned figures is text. You can confirm it with =ISNUMBER(A2), which returns TRUE for a real number and FALSE for text. A green triangle in the top-left of a cell, or a warning that says the number is stored as text, is the same signal. Any of these means run one of the conversions above before you trust a total.
Build the habit of checking alignment and running a test sum right after every conversion. It takes a few seconds and it catches the partial-text case before it skews a reconciliation. For the broader set of issues that show up after a conversion, the guide on PDF to Excel formatting problems covers merged cells, split rows, and misaligned columns alongside this one.
The pattern behind all of it is the same: get clean, typed data out of the PDF first, then build on it. Start with the PDF to Excel converter above, confirm the amounts are right-aligned and total correctly, and you avoid the cleanup altogether. The same discipline applies wherever your figures live: if they are on receipts, pull the amounts straight into a sheet with a receipt to Excel converter, and if they arrive as emailed reports, an email parser that exports to Excel keeps the numbers numeric on the way in.