Cut an amount to cents without rounding
Turn 1.999 into $1.99 when the destination says to cut, not round.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The amount, like 1.999. | 1.999 |
| 2 | ,2 | Keeps two decimal places, the cents. | 2 places |
| 3 | TRUNC( … ) | Cuts off the rest, without rounding. | $1.99 |
Cutting moves toward zero: -1.999 becomes -$1.99, not -$2.00. The amounts are made-up.
=TRUNC(A8,2)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 into the green column of the Template tab. The cut amounts fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only when the destination asks to cut extra decimals. Most need normal rounding.
Microsoft's help: TRUNC function
OTHER ROUTES YOU MIGHT LIKE

Round amounts away from zero to cents
1.001 → 1.01; -1.001 → -1.01
Get the template →
Round amounts to the nearest five cents
12.33 → 12.35
Get the template →
Round amounts up to the next five cents
1.21 → 1.25
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →