Turn cents into amounts, flag part cents
Turn 12345 cents into 123.45, and flag 123.5 or text for a look.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | AND(ISNUMBER(A8),A8=INT(A8)) | Checks the cell is a number with no part cents. | TRUE |
| 2 | A8/100 | Divides by 100 to turn cents into an amount. | 123.45 |
| 3 | "Review: not whole cents" | The message when the check fails. | Not used for row 8 |
| 4 | IF( … ) | Uses part 2 when the check passes, otherwise part 3. | 123.45 |
| 5 | IFERROR( … ,"Review: not whole cents") | Shows the same message if the cell holds an error. | 123.45 |
Excel works from the inside out. Minus amounts and zero are fine.
=IFERROR(IF(AND(ISNUMBER(A8),A8=INT(A8)),A8/100,"Review: not whole cents"),"Review: not whole cents")How 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 cent counts into the green column of the Template tab. The amounts fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Use this only when your source sends whole cents in one currency. It only divides by 100.
Microsoft's help: IS functions
OTHER ROUTES YOU MIGHT LIKE

Read amount text 00000123M as -12.34
00000123M → -12.34
Get the template →
Read CR as negative and DR as positive
125.50 CR → -125.5
Get the template →
Read exact 1,234.50 amount text
1,234.50 → 1234.5; 1,23.00 → Review amount pattern
Get the template →
Show $1,234.50 instead of 1234.5 in a mail merge
1234.5 → $1,234.50
Take this route →