Bought Pro? Your keys are in your account. Sign in

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 DR is money out, 18,750.00 CR money in.
  • Unicode minus: −12.40 uses U+2212, which looks like a hyphen but is not one. VALUE returns #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.

Before As copied from the web page
DateDescriptionAmount
03/09/2026CARD PURCHASE LULU HYPERMARKET(245.60)
05/09/2026REFUND AMAZON.AE89.00
08/09/2026DEWA BILL PAYMENT(1,120.35)
11/09/2026STANDING ORDER RENT4,500.00-
15/09/2026SALARY SEP 202618,750.00 CR
20/09/2026ANNUAL CARD FEE315.00 DR
24/09/2026FX ADJUSTMENT−12.40
After Cleaned by StatementTidy
DateDescriptionAmount
2026-09-03CARD PURCHASE LULU HYPERMARKET-245.60
2026-09-05REFUND AMAZON.AE89.00
2026-09-08DEWA BILL PAYMENT-1120.35
2026-09-11STANDING ORDER RENT-4500.00
2026-09-15SALARY SEP 202618750.00
2026-09-20ANNUAL CARD FEE-315.00
2026-09-24FX 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

  1. Install StatementTidy. Download the free extension and load it in Chrome, Edge or Brave.
  2. Open the page with the table. A statement, ledger, broker or ERP report in your browser.
  3. Click the StatementTidy icon. Bracketed, trailing-minus, DR and Unicode-minus values are converted to signed numbers automatically.
  4. 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.