Guide · StatementTidy
How to fix negative numbers in brackets in Excel
Short answer
Accounting systems write negatives as (1,120.35), 4,500.00- or 315.00 DR. When pasted from a web page these often stay text. In Excel, use Text to Columns (with “Trailing minus for negative numbers”) or a SUBSTITUTE formula. StatementTidy reads all of these forms, plus −12.40 with a Unicode minus and CR for credits, and outputs real signed numbers.
Last updated · by Mumshad Jawad
Why this happens
Brackets are the accountant’s minus sign. Excel does understand (1,120.35) when you type it, but copied web tables add things that stop the conversion: a non-breaking space inside the bracket, a currency code, a different thousands separator. Other notations Excel never converts by itself:
- Trailing minus:
4,500.00-, common in ERP and broker exports. - DR / CR suffixes:
315.00 DRis money out,18,750.00 CRmoney in. - Unicode minus:
−12.40uses U+2212, which looks like a hyphen but is not one.VALUEreturns#VALUE!.
Real example: before and after
The rows below are fictional. The “after” table is not a mock-up: this page ran them through StatementTidy’s cleaning engine (the same clean.js the extension uses, v1.0.1) with its default options, and shows exactly what you would export.
| Date | Description | Amount |
|---|---|---|
| 03/09/2026 | CARD PURCHASE LULU HYPERMARKET | (245.60) |
| 05/09/2026 | REFUND AMAZON.AE | 89.00 |
| 08/09/2026 | DEWA BILL PAYMENT | (1,120.35) |
| 11/09/2026 | STANDING ORDER RENT | 4,500.00- |
| 15/09/2026 | SALARY SEP 2026 | 18,750.00 CR |
| 20/09/2026 | ANNUAL CARD FEE | 315.00 DR |
| 24/09/2026 | FX ADJUSTMENT | −12.40 |
| Date | Description | Amount |
|---|---|---|
| 2026-09-03 | CARD PURCHASE LULU HYPERMARKET | -245.60 |
| 2026-09-05 | REFUND AMAZON.AE | 89.00 |
| 2026-09-08 | DEWA BILL PAYMENT | -1120.35 |
| 2026-09-11 | STANDING ORDER RENT | -4500.00 |
| 2026-09-15 | SALARY SEP 2026 | 18750.00 |
| 2026-09-20 | ANNUAL CARD FEE | -315.00 |
| 2026-09-24 | FX ADJUSTMENT | -12.40 |
- Date column converted to ISO YYYY-MM-DD (DD/MM detected)
- 5 negative amounts as real negative numbers
Open this example in the live demoEdit the rows, paste your own table, toggle options. Nothing is uploaded.
How to fix it by hand in Excel
Brackets: a formula
With the text in A2:
=IF(LEFT(TRIM(A2),1)="(", -VALUE(SUBSTITUTE(SUBSTITUTE(TRIM(A2),"(",""),")","")), VALUE(TRIM(A2)))
Or select the column and use Ctrl+H: replace ( with -, then ) with nothing.
Trailing minus: Text to Columns
Select the column, Data → Text to Columns → Delimited → Next → Next → Advanced…, tick Trailing minus for negative numbers, then OK → Finish.
DR / CR and the Unicode minus
These need one more IF or SUBSTITUTE(A2,"−","-") each, which is where one-formula-per-format gets fragile on a real statement that mixes them.
Keep the brackets on screen
Once the values are real negatives you can still display brackets: Format Cells → Custom → #,##0.00;(#,##0.00). The value stays a number.
How to fix it in one click with StatementTidy
- Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
- Open the page with the table. A statement, ledger, broker or ERP report in your browser.
- Click the StatementTidy icon. Bracketed, trailing-minus, DR and Unicode-minus values are converted to signed numbers automatically.
- Copy for Excel. Paste into Excel or Google Sheets; the column sums correctly straight away.
Get StatementTidy free for ChromeTry it on a sample statement
Questions
Why does SUM ignore my bracketed numbers?
Because the cells are text, not numbers. SUM skips text without an error. Check with =ISNUMBER(A2): FALSE means the cell needs converting.
Does CR always mean positive?
In StatementTidy, a CR suffix makes the amount positive and DR makes it negative, which is how bank and card statements use them. If your report uses the opposite convention, flip the sign of the column after export.