Put the decimal point back in amounts
When an export says the scale is 2, turn 12345 into 123.45.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The whole number from the export. | 12345 |
| 2 | B8 | How many decimal places the source says. | 2 |
| 3 | 10^ … | 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^B8How 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 numbers. Paste whole numbers into column A and the scale your source gives into column B of the Template tab.
- 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.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Read text amounts in a mixed column
1,234.56 as text → 1234.56; numbers stay as they are
Get the template →
Build an amount from units and cents
-12 units and -34 cents → -$12.34
Get the template →
Read amounts in the required currency
USD 1,234.56 (USD required) → 1234.56
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →