Why percentages show 100 times too big in Excel
Formula (Excel and Google Sheets)
=B2/100The cells hold 15 instead of 0.15. Divide by 100 before formatting as a percentage: =B2/100.
- Result on the example
- one result per row in
C2, filled down toC6 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in C2, filled down to C6. Change any input and the result updates, or edit the formula to experiment.
How it works
The Percent format multiplies the stored value by 100 for display, so 15 shows as 1500%. The data meant 15%, which is stored as 0.15. Dividing by 100 gives the right value, and the same format then shows 15%.
=B2/100Result0.15
B21500%The value in B2.
B2/1000.15The / operator divides.
In Google Sheets
The same formula works in Google Sheets: =B2/100. We ran it in Google Sheets mode on the same data and it returns the same results.
Other ways to do it
Each one was run on the same example sheet.
| Formula | Result | When to use it |
|---|---|---|
| =B2% | 15%, 7.5%, 22%… | The % sign after a reference divides it by 100, the same as /100. |
Common mistakes
- Typing 15 into a cell that is already formatted as Percent stores 0.15 (Excel converts as you type), but formatting existing numbers doesn't. That is why imported or pasted values come out 100 times too big.
- Don't multiply by 100 and format as a percentage too; use one or the other.
Try it yourself
Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.
Why percentages show 100 times too big
C2, turn the imported rate into a proper percentage, then fill down to C6.Questions
How do I fix the column in place?
Type 100 in a spare cell, copy it, select the rates, then Paste Special, Divide. Format the column as Percent.
Why does my formula like =A2/B2*100 show 4500%?
Multiplying by 100 and then applying the Percent format doubles the scaling. Drop the *100.
Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.