Write percentage points as percent text
Turn 12.5 into the label 12.5% for letters, not 1250%.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8/100 | Divides the points by 100 to make a rate. | 0.125 |
| 2 | "0.0%" | The pattern: one decimal, then a percent sign. | "0.0%" |
| 3 | TEXT( … ) | Writes the rate using that pattern. | "12.5%" |
The % sign in the pattern multiplies by 100 again, so 0.125 shows as 12.5%. The result is text, rounded to one decimal.
=TEXT(A8/100,"0.0%")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 percentage points into the green column of the Template tab. The labels 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 for points, like 12.5 for 12.5%. A rate already stored as 0.125 would show as 0.1%.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Write a percent with chosen decimals
0.125, 1 decimal → 12.5%
Get the template →
Write a part of a total as a percent
1 and 4 → 25.0%; 2 and 0 → Review zero total
Get the template →
Write a label like +5.0 percentage points
0.05 → +5.0 percentage points
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →