You convert a financial PDF to Excel, the figures look right, and then a credit or a loss that should read as a negative refuses to behave. A value the statement showed as (1,234.56) in parentheses sits in the cell looking fine, but =SUM() skips it, your subtotal is off by exactly that amount, and the column total no longer ties. The accounting convention of wrapping negatives in parentheses, which every income statement and bank statement uses, is the single most common reason amounts come across as text instead of real numbers.
This is fixable in seconds once you know what causes it. Below is why parenthesized negatives turn into text, how to spot which cells are affected, and the fastest ways to convert them back into numbers that calculate. The converter at the top of this page writes negatives as real numeric values (it reads the parentheses and the trailing minus correctly), so try your file first, then use these fixes for anything Excel still flags. It is a close cousin of the problem where all your numbers come in as text, just the version that bites accountants hardest because it throws off the sign.
Why do negative numbers in parentheses come in as text from a PDF?
Negatives in parentheses come in as text because the converter or paste hands Excel the literal string (1,234.56), and Excel only auto-reads parentheses as a negative when you type them directly into a cell, not when they arrive as imported text. The same happens with a trailing minus like 1,234.56- that some statements use. Excel sees a label, left-aligns it, and its math functions ignore it.
Currency symbols, thousands separators, and stray spaces make this worse, because they push Excel further away from recognizing the string as a number. The fix is to strip the formatting characters and convert the remaining value, keeping the negative sign intact.
How do I tell which numbers are stored as text in Excel?
The fastest check is alignment: real numbers sit on the right edge of the cell by default, while text-formatted numbers sit on the left. Select a column of amounts and look at the bottom status bar; if Excel shows a Count but no Sum or Average, those cells are text.
For a definitive test, put =ISNUMBER(C2) in an empty cell next to an amount. TRUE means it is a real number, FALSE means it is text. You can also use =TYPE(C2): a result of 1 is a number, 2 is text. A small green triangle in the top-left corner of cells is Excel's own warning that a number is stored as text.
How do I convert parentheses negatives to real negative numbers in Excel?
The quickest fix for a whole column is Text to Columns. Select the column, go to Data > Text to Columns, choose Delimited, click Next twice, set the column format to General, and finish. Excel re-parses each cell and converts (1,234.56) to a true negative -1234.56 that sums correctly.
If Text to Columns does not catch the parentheses, use a helper formula: =IF(LEFT(A2,1)="(", -VALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,"(",""),")",""),",","")), VALUE(SUBSTITUTE(A2,",",""))). This removes the parentheses and commas, multiplies the result by negative one when the value was wrapped, and returns a clean number. Copy the helper column, then Paste Special > Values over the originals.
How do I fix a trailing minus sign like 1,234.56-?
Some accounting systems print the negative sign to the right of the amount, so the cell holds 1,234.56- as text. Excel will not read a trailing minus as negative. To fix it, strip the rightmost character and multiply by negative one: =IF(RIGHT(A2,1)="-", -VALUE(LEFT(A2,LEN(A2)-1)), VALUE(A2)).
Wrap the value part in SUBSTITUTE(...,",","") if the amounts carry thousands separators. As before, paste the formula results back as values once the column reads correctly, then delete the helper column.
Why does my SUM total ignore the negatives after converting a PDF?
SUM ignores text, so if your negatives arrived as parenthesized strings, they contribute zero to the total and your column comes out too high by the sum of those entries. The give-away is a total that is off by a round, traceable amount rather than a few cents. Convert the text cells to real numbers using Text to Columns or the formulas above, and SUM will pick them up immediately.
After any conversion, reconcile the new column total against the total printed on the original PDF. If the two tie to the cent, every negative converted correctly; if they differ, you still have stragglers stored as text. This is the same discipline you would apply when you reconcile a bank statement in Excel, where a single text-formatted credit can hide a whole reconciliation difference.
How do I display Excel negatives back in parentheses after fixing them?
Once the cells hold real negative numbers, you can show them in accounting style again with a custom format, which keeps the value numeric while displaying parentheses. Select the cells, press Ctrl+1, choose Custom, and enter #,##0.00_);(#,##0.00). Negatives now show as (1,234.56) but still calculate.
This is the right order of operations: convert to real numbers first so the math works, then apply the parentheses as a display format. Never leave the parentheses as literal text, or your sums break all over again.
How do I stop negatives from importing as text in the first place?
Use a converter that detects accounting-format negatives during extraction, so the values arrive numeric and you skip the cleanup entirely. The converter at the top of this page reads both parentheses and trailing-minus conventions and writes each amount as a real number, with the negative sign in place, so totals tie on the first try. The same is true for converting a financial report PDF to Excel, where keeping every figure numeric is what lets your subtotals and SUM formulas survive the move.
If you are pulling many statements, this matters at scale: cleaning negatives by hand across dozens of files is slow and error-prone, and one missed cell throws off a reconciliation. Getting numeric output at the source is the difference between a total that ties and an afternoon of chasing a variance. When those numbers come off bank statements specifically, where debits and credits both carry signs, a dedicated bank statement to Excel converter handles the accounting negatives the same way, and if the cleaned data is headed into QuickBooks, you can take it straight from a CSV to QBO converter instead of re-keying it.
A quick checklist for negatives after a PDF to Excel conversion
Run through this whenever a converted total does not tie:
- Check alignment and the status-bar Sum to spot text-formatted amounts.
- Confirm with
=ISNUMBER()on a sample cell. - Run Data > Text to Columns on the amount column to mass-convert.
- For stubborn cells, use the parentheses or trailing-minus formula, then Paste Special > Values.
- Reapply the accounting display format
#,##0.00_);(#,##0.00)for parentheses that still calculate. - Reconcile the Excel total against the PDF total to confirm every negative converted.
Most negative-number problems trace back to the original conversion treating parentheses as text. Start with a converter that handles accounting negatives natively, and the cleanup mostly disappears. If you do this work daily, our PDF to Excel for accountants page covers the full statement-to-spreadsheet workflow, signs and subtotals included.