Build an amount from units and cents

Turn -12 whole units and -34 cents into -$12.34.

What you'll make

In Excel: -12 units and -34 cents becomes -$12.34.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The whole units, like -12.-12
2B8The cents, like -34.-34
3/100Divides the cents by 100.-0.34

The + adds part 1 to the cents from part 3: -12 plus -0.34 is -12.34. The amounts are made-up.

=A8+B8/100

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 whole units into column A and cents into column B of the Template tab.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check both cells carry the same sign. A negative amount needs a minus on the units and the cents.