Turn currency text into a number
Remove a known label like $ so -$1,234.50 becomes the number -1234.5.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The amount, written as text. | "-$1,234.50" |
| 2 | B8 | The currency label to remove. | "$" |
| 3 | SUBSTITUTE( … ,"") | Takes the label out of the amount. | "-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,B8,""),".",",")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. On the Template tab, paste amounts into column A. Put the label they use, like $ or USD, into column B.
- 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. Amounts like 1.234,50 or (40.00) need a look first.
Microsoft's help: NUMBERVALUE function
OTHER ROUTES YOU MIGHT LIKE

Read amounts like 1.234,56 as numbers
1.234,56 € → 1234.56
Get the template →
Read space-grouped amounts
1 234,56 EUR → 1234.56
Get the template →
Read parentheses as a negative amount
($1,234.50) → -1234.5
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →