Export an amount as whole cents

Turn 123.45 into 12345 cents for exports that need a whole number.

What you'll make

In Excel: 123.45 becomes 12345 cents.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The amount in dollars, like 123.45.123.45
2*100Times 100, the cents in one dollar.12345
3ROUND( … ,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.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own amounts. Paste amounts into the green column of the Template tab. The cents fill in by themselves.
  3. 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