Put the decimal point back in amounts

When an export says the scale is 2, turn 12345 into 123.45.

What you'll make

In Excel: 12345 with scale 2 becomes 123.45.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The whole number from the export.12345
2B8How many decimal places the source says.2
310^ …Turns the scale into 100, 1,000 and so on.100

The / divides part 1 by part 3, so 12345 becomes 123.45. The numbers are made-up.

=A8/10^B8

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 numbers. Paste whole numbers into column A and the scale your source gives 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

Use the scale your source documents. Don't guess it from the size of the amount.