Write amounts like 1234,50
Turn 1234.5 into 1234,50 for a system that wants a comma before the cents.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | ROUND(A8,2) | Rounds the amount to cents. | 1234.5 |
| 2 | TEXT( … ,"0.00") | Writes it with two decimals and no thousands commas. | "1234.50" |
| 3 | SUBSTITUTE( … ,".",",") | Swaps the decimal point for a comma. | "1234,50" |
Each bracket wraps the one before it, so Excel works from the inside out. The amounts are made-up.
=SUBSTITUTE(TEXT(ROUND(A8,2),"0.00"),".",",")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, as numbers, into the green column of the Template tab. The results fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check that the system you send to wants a comma before the cents. This works when your Excel uses a decimal point.
Microsoft's help: SUBSTITUTE function



