Turn percentage points into a rate
Turn 12.5 into the rate 0.125, shown as 12.5%.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The percentage points, like 12.5. | 12.5 |
| 2 | /100 | Divides by 100 to make a rate. | 0.125, shown as 12.5% |
The result is the number 0.125. The Percentage format shows it as 12.5%.
=A8/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 numbers. Paste percentage points into the green column of the Template tab. The rates 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 become 0.1%.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Turn a rate into percentage points
12.5% as a rate → 12.5 as points
Get the template →
Read percent text with no % sign
12.5 as text → 0.125
Get the template →
Turn basis points into a rate
125 basis points → 1.25% as a rate
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →