Get the fraction part, keeping its sign
Turn -1.5 into -0.5, so a minus number keeps its minus sign.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The number, like -1.5. | -1.5 |
| 2 | TRUNC(A8) | The whole part, cut toward zero. | -1 |
The minus sign between them takes part 2 away from part 1: -1.5 minus -1 is -0.5. A whole number gives 0.
=A8-TRUNC(A8)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 numbers. Paste numbers into the green column of the Template tab. The fraction parts fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Some results are off by a tiny hidden amount, like 2.3 giving 0.3 that isn't exactly 0.3. Round before comparing.
Microsoft's help: TRUNC function
OTHER ROUTES YOU MIGHT LIKE

Round values to the nearest fraction
0.26 to the nearest 1/4 → 0.25
Get the template →
Add two fractions from separate fields
1/2 + 1/4 → 0.75
Get the template →
Subtract fractions from separate fields
3/4 - 1/2 → 0.25
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →