Export an amount as whole cents
Turn 123.45 into 12345 cents for exports that need a whole number.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The amount in dollars, like 123.45. | 123.45 |
| 2 | *100 | Times 100, the cents in one dollar. | 12345 |
| 3 | ROUND( … ,0) | Rounds to the nearest whole cent. | 12345 |
Rounding tidies amounts with extra decimals: 19.999 becomes 2000. Half a cent rounds away from zero. The amounts are made-up.
=ROUND(A8*100,0)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 cents 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 counts 100 cents to a unit. Some currencies use other scales.
Microsoft's help: ROUND function
OTHER ROUTES YOU MIGHT LIKE

Export a signed nine-digit cent amount
123.45 → +000012345
Get the template →
Write negative amounts like 123.45-
-123.45 → 123.45-
Get the template →
Write a two-decimal amount like 1234.50
1234.5 → text 1234.50
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →