Build an amount from units and cents
Turn -12 whole units and -34 cents into -$12.34.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The whole units, like -12. | -12 |
| 2 | B8 | The cents, like -34. | -34 |
| 3 | /100 | Divides 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/100How 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 whole units into column A and cents 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
Check both cells carry the same sign. A negative amount needs a minus on the units and the cents.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Read amounts in the required currency
USD 1,234.56 (USD required) → 1234.56
Get the template →
Turn currency text into a number
-$1,234.50 minus the $ label → -1234.5
Get the template →
Read amounts like 1.234,56 as numbers
1.234,56 € → 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 →