Write dollar amounts, keeping blanks
Turn 1234.5 into $1,234.50 for a letter. Blank cells stay blank.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8="" | Checks whether the amount cell is empty. | Not empty |
| 2 | TEXT(A8,"$#,##0.00") | Writes the amount with $, commas and cents. | "$1,234.50" |
| 3 | IF( … ) | Picks blank or the written amount. | "$1,234.50" |
An empty cell stays empty, but a real 0 shows as $0.00. The amount in the cell doesn't change. The amounts are made-up.
=IF(A8="","",TEXT(A8,"$#,##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
Leave a missing amount empty rather than typing 0, so the letter doesn't show $0.00 by mistake.
Microsoft's help: TEXT function



