Label an amount with its currency
Turn 1234.5 into USD 1,234.50 with the label and decimals you choose.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8 | The currency label, like USD. | "USD" |
| 2 | &" "& | Adds one space after the label. | "USD " |
| 3 | IF(C8=0, … ) | Adds a decimal point and one 0 per decimal. | ".00" |
| 4 | TEXT(A8,"#,##0"& … ) | Writes the amount with commas and those decimals. | "USD 1,234.50" |
Excel works from the inside out: part 3 builds the pattern, then part 4 uses it. With 0 decimals there is no decimal point. The amounts are made-up.
=B8&" "&TEXT(A8,"#,##0"&IF(C8=0,"","."&REPT("0",C8)))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, currency labels and decimals into the green columns of the Template tab.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
This only adds a label. It doesn't convert currencies, so check each label matches its amount.
Microsoft's help: TEXT function



