You converted a statement or report from PDF to Excel, dropped a SUM under a column of dollar amounts, and got 0 or a tiny wrong figure. The values look right on screen, $1,234.56 sitting there exactly as it did in the PDF, but Excel will not add them. The usual cause is that the currency symbol and the thousands commas came across as part of the text, so Excel sees the whole thing as a label, not a number. This is one of the most common ways a conversion looks perfect and quietly breaks your totals.
Convert the file with the PDF to Excel converter at the top of this page, then use the steps below to clean up any amounts that landed as text.
Why do currency symbols come in as text after a PDF to Excel conversion?
Currency symbols come in as text because the PDF stored the dollar sign and commas as literal characters next to the digits, and a conversion that copies what it sees keeps them attached. Excel only treats a cell as a number when the whole cell is numeric. The moment a $ or a comma is part of the value rather than the display format, Excel reads $1,234.56 as text, and text is ignored by SUM, AVERAGE, MIN, and MAX.
There is an important distinction here. A dollar sign that comes from Excel's format (Accounting or Currency) sits on top of a real number, and that number sums fine. A dollar sign that is part of the value is text. The two look identical in the cell. The next section shows how to tell them apart.
How can I tell if an amount is a real number or text?
The fastest tell is alignment: by default Excel right-aligns numbers and left-aligns text, so a column of amounts hugging the left edge is text. To confirm, click a cell and type =ISNUMBER(A2) in an empty cell. TRUE means it is a real number; FALSE means it is text. You can also select the column and read the status bar at the bottom right: if Sum shows a value, they are numbers; if only Count appears, they are text.
A small green triangle in the top-left corner of the cells, with a warning that says "Number Stored as Text," is the clearest signal of all. When you see that, the fix below takes seconds.
How do I fix currency amounts that came in as text?
For a whole column, the quickest fix is Text to Columns. Select the column, go to Data, click Text to Columns, choose Delimited, and click Finish immediately without changing anything. That forces Excel to re-parse each cell, and clean amounts convert straight to numbers. If the dollar sign and commas were the only problem, this alone usually fixes it.
If Text to Columns leaves the $ in place, the values have the symbol baked in and need stripping. Put this formula in an empty column: =SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")*1. The inner SUBSTITUTE removes the dollar sign, the outer one removes the commas, and multiplying by 1 turns the cleaned text into a real number. Copy it down the column, then select the results, Copy, and Paste Special > Values back over the originals so you keep numbers, not formulas.
How do I remove the dollar sign and commas in one step?
Use a nested SUBSTITUTE wrapped in VALUE or followed by *1. The formula =SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")*1 strips both characters and returns a true number in a single pass. If your amounts also carry a currency code like USD, add another SUBSTITUTE layer for it. For very messy cells with stray spaces, wrap the whole thing in TRIM and CLEAN first: =VALUE(TRIM(CLEAN(SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")))).
Avoid the DOLLAR function for this job. DOLLAR returns text, so it would take you in the wrong direction. You want a number first, then formatting on top.
Why does my SUM still return 0 after I removed the symbols?
If SUM is still 0, the cells are most likely still text even though the $ is gone. A leading apostrophe, a non-breaking space (common in conversions), or a trailing space all keep a value text even after you delete the dollar sign. Run =ISNUMBER on a cell to confirm. If it is still FALSE, do the SUBSTITUTE-and-multiply formula above, or select the range, click the yellow warning icon, and choose Convert to Number.
Another quiet culprit is a hidden character where a thousands separator used to be. If commas were rendered as a special glyph in the PDF, a plain SUBSTITUTE for "," will miss them. In that case Text to Columns with a custom delimiter, or a Find and Replace on the exact character, clears it.
How do I get the currency formatting back without breaking the numbers?
Convert the text to real numbers first, then apply formatting on top. Once the column is genuine numbers, select it, press Ctrl+1 to open Format Cells, and choose Accounting or Currency. That puts the dollar sign and commas back as a display layer, so the cells still calculate while looking the way you expect. The order matters: format first and the values stay text; clean first and they sum.
The Accounting format (Home > Number > Accounting Number Format) lines up the dollar signs and decimals down the column, which is what most finance reports expect.
How do I stop currency amounts converting to text in the first place?
Start with a converter that extracts the number and leaves the symbol as formatting rather than baking it into the value. A table-aware tool that recognizes a currency column keeps the amounts numeric, which means no cleanup at all on the far side. For digital PDFs with a real text layer this is the norm; for scanned documents, OCR quality drives whether $ and commas come through cleanly, so a clean scan helps.
Whatever tool you use, build a habit of checking one column with =ISNUMBER and tying the SUM to the printed total on the PDF before you trust the file. That 30-second check catches text-amount problems immediately, while the file is still small enough to fix.
Quick checklist for currency amounts that came in as text
- Spot it: amounts left-aligned, a green triangle, or the status bar showing Count but no Sum.
- Confirm it: =ISNUMBER(cell) returns FALSE.
- Fast fix: select the column, Data > Text to Columns > Finish.
- Stubborn fix: =SUBSTITUTE(SUBSTITUTE(A2,"$",""),",","")*1, then Paste Special > Values.
- Reformat: convert to real numbers first, then Ctrl+1 > Accounting.
- Verify: SUM the column and tie it to the PDF's printed total.
If you are cleaning amounts off a converted bank statement, the same approach applies to every debit and credit; our sibling tool for that exact job is the bank statement to Excel converter. And once the numbers are clean and ready for your accounting software, you can move them on with a CSV to QBO converter so the data lands in QuickBooks without re-keying.
For more on amounts that arrive in the wrong shape, see how to handle numbers that come in as text, negative numbers in parentheses, and how to convert a PDF to Excel accurately the first time.