Write a signed percent like +12.5%
Turn a change of 0.125 into +12.5%, with a minus for falls and 0.0% for none.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The change, where 1 means 100%. | 0.125 |
| 2 | "+0.0%; | How rises look: a plus sign and one decimal. | "+12.5%" |
| 3 | -0.0%; | How falls look: a minus sign and one decimal. | Not used for row 8 |
| 4 | 0.0%" | How no change looks: 0.0%, with no sign. | Not used for row 8 |
| 5 | TEXT( … ) | Writes the change as text in the matching pattern. | "+12.5%" |
The semicolons split the pattern into rises, falls and no change. The number in the cell doesn't change.
=TEXT(A8,"+0.0%;-0.0%;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 changes, as numbers, 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 changes where 1 means 100%. A change typed as 12.5 would show as +1250.0%.
Microsoft's help: TEXT function
OTHER ROUTES YOU MIGHT LIKE

Write percentage points as percent text
12.5 as points → 12.5% as text
Get the template →
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 →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →