Why Do Numbers From a PDF Table Import as Text in Excel?

The digits look right, but SUM returns 0 and sorting puts 100 before 9. Here is why converted numbers sometimes land as text instead of values, and how to fix it in seconds.

You extract a table from a PDF, the numbers appear exactly where they should, and then =SUM(B2:B20) returns 0. Or the column sorts 1, 10, 100, 2, 20 instead of numerically. Excel is telling you, in its own indirect way, that what looks like a number in that cell is actually a text string that happens to be made of digits.

Why this happens

A PDF stores text as characters positioned on a page — it has no concept of “this is a number” versus “this is a label,” they’re both just glyphs at coordinates. When a converter reconstructs a table from that, it reads what’s visually a numeric column and drops it into cells as the literal text it saw, digit for digit. Most of the time Excel’s own type detection catches this and converts it automatically, but specific formatting in the source PDF defeats that detection reliably:

  • A currency symbol or thousands separator baked into the text — $1,240.00 or 1.240,50 (European format) reads as text because of the symbol and separator characters, not because the underlying number is wrong.
  • A trailing or leading space copied along with the digits during extraction — invisible in the cell, but enough to make Excel treat it as text.
  • Numbers in parentheses for negatives — accounting notation like (450.00) for negative 450 is a text pattern Excel doesn’t automatically reinterpret as a negative value.
  • A non-breaking space or other invisible Unicode character from the original PDF’s font encoding, sitting between digits or as a separator.

The fast fix: Text to Columns

Select the affected column, then Data → Text to Columns → Delimited → Finish (you don’t need to actually split anything — running a column through this wizard and clicking through to Finish forces Excel to re-evaluate every cell’s type from scratch, converting genuine numeric text into real numbers as a side effect). This fixes the vast majority of cases in one action, including the invisible-space problem, without you needing to identify which specific issue it was.

If that doesn’t catch it

  • Multiply by 1. In an empty cell, enter =B2*1 and fill down — this forces a numeric conversion cell by cell, useful when Text to Columns doesn’t fully resolve it.
  • Strip currency symbols and separators directly with =VALUE(SUBSTITUTE(SUBSTITUTE(B2,"$",""),",","")), which removes the specific characters defeating detection before converting.
  • Check for accounting-format negatives manually if a column has parenthesized numbers — =VALUE(SUBSTITUTE(SUBSTITUTE(B2,"(","-"),")","")) converts (450.00) into a real -450.

Getting a cleaner extraction in the first place

PDF to Excel works best on PDFs where the table has genuine text you can select with your cursor in the original — the numbers exist as real characters, not a photograph of them, which gives the extraction the best chance of reading clean digits without stray formatting characters attached. A scanned PDF table is read through OCR instead of direct text extraction, which is more prone to exactly the kind of stray-character noise that produces text-formatted numbers — see Convert a Bank Statement PDF to Excel for more on getting a clean result from that specific, very common case.

After fixing the column

Once numbers behave as numbers — SUM returns a real total, sorting behaves numerically — the rest of the sheet works normally: formulas, conditional formatting, and charts all read the column correctly from that point on.

Ready? Try the free PDF to Excel tool now — no sign-up, no watermark, and your file is never stored.

All articles