Read parentheses as a negative amount
Turn accounting text like ($1,234.50) into the number -1234.5.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | IF( … ) | Gives -1 when the amount starts with a bracket, otherwise 1. | -1 |
| 2 | SUBSTITUTE( … ) | Takes out the $ sign and both brackets. | "1,234.50" |
| 3 | NUMBERVALUE( … ,".",",") | Reads it as a number. A period marks decimals. | 1234.5 |
Parts 2 and 3 work from the inside out. The * multiplies part 3 by part 1, so ($1,234.50) gives -1234.5. The amounts are made-up.
=IF(LEFT(TRIM(A8),1)="(",-1,1)*NUMBERVALUE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TRIM(A8),"$",""),"(",""),")",""),".",",")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own amounts. Paste amounts like ($1,234.50) into the green column of the Template tab. The numbers fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
A minus sign inside brackets, like (-$40.00), comes out positive. Check those first.
Microsoft's help: NUMBERVALUE function
OTHER ROUTES YOU MIGHT LIKE

Read amounts like 90.02- as negatives
90.02- → -90.02
Get the template →
Expand K or M amounts to full numbers
1.2K → 1200
Get the template →
Treat an accounting dash as zero
A dash - → 0, a blank stays blank
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →