Read percent text like 12,5% as rates

Turn the text 12,5% into the number 0.125, when a comma marks decimals.

What you'll make

In Excel: 12,5% as text becomes 0.125.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The percent text, like 12,5%."12,5%"
2","A comma marks the decimals."12,5%"
3"."A period groups thousands, like 1.250%."12,5%"
4NUMBERVALUE( … )Reads the text as a number. The % divides by 100.0.125

The result is a plain number. To show it as a percentage again, use Excel's Percentage format.

=NUMBERVALUE(A8,",",".")

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own percentages. Paste percent text into the green column of the Template tab. The numbers fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

Check your source uses a comma for decimals. Text like 12.5% would be read as 125%.

Microsoft's help: NUMBERVALUE function