Convert a math minus sign in amounts
Turn −1,234.50, typed with a math minus sign, into the number -1234.5.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The amount as text, with a math minus sign (−). | "−1,234.50" |
| 2 | UNICHAR(8722) | The math minus sign. It looks like a dash. | "−" |
| 3 | SUBSTITUTE( … ,"-") | Swaps it for the plain minus sign (-). | "-1,234.50" |
| 4 | NUMBERVALUE( … ,".",",") | Reads it as a number. A period marks decimals. | -1234.5 |
Each bracket wraps the one before it, so Excel works from the inside out. The amounts here are made-up.
=NUMBERVALUE(SUBSTITUTE(A8,UNICHAR(8722),"-"),".",",")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 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
This only works when a period marks decimals. Other dashes, like an en dash, still need a look.
Microsoft's help: UNICHAR function
OTHER ROUTES YOU MIGHT LIKE

Put the decimal point back in amounts
12345 with scale 2 → 123.45
Get the template →
Read text amounts in a mixed column
1,234.56 as text → 1234.56; numbers stay as they are
Get the template →
Build an amount from units and cents
-12 units and -34 cents → -$12.34
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →