Write dollar thousands like $1.5k
Turn 1500 into an approximate $1.5k for a summary.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8/1000 | Turns the amount into thousands. | 1.5 |
| 2 | "$0.0" | The pattern: $ and one decimal place. | "$0.0" |
| 3 | TEXT( … ) | Writes the thousands as text in that pattern. | "$1.5" |
| 4 | &"k" | Adds k, meaning thousand. | "$1.5k" |
The result is rounded to the nearest hundred dollars. The amount in the cell doesn't change. The amounts are made-up.
=TEXT(A8/1000,"$0.0")&"k"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
Use $1.5k only where a rough amount is fine. Show the exact amount for anything someone has to pay.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Label an amount with its currency
1234.5, USD, 2 decimals → USD 1,234.50
Get the template →
Write dollar amounts, keeping blanks
1234.5 → $1,234.50
Get the template →
Show negative dollars in parentheses
-1234.5 → ($1,234.50)
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →