Why does my percentage show as a decimal in Excel?
Formula (Excel and Google Sheets)
=B2/C2A percentage is stored as a fraction (0.75). Keep the formula =B2/C2 and apply the % number format; don't multiply by 100.
- Result on the example
- one result per row in
D2, filled down toD6 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in D2, filled down to D6. Change any input and the result updates, or edit the formula to experiment.
How it works
A percentage is a fraction: 18 of 24 is 0.75. The % format displays that value times 100 with a percent sign, as 75.0%, without changing it. So the formula only divides, and the format does the rest.
=B2/C2Result0.75
B218The value in B2.
C224The value in C2.
B2/C20.75The / operator divides.
In Google Sheets
The same formula works in Google Sheets: =B2/C2. 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 |
|---|---|---|
| =ROUND(B2/C2,3) | 75.0%, 35.0%, 100.0%…Different result | Rounds the stored value to 0.1%, so it matches what is shown. Ads is stored as 18.8% instead of 18.75%. |
| =B2/C2*100 | 7500.0%, 3500.0%, 10000.0%…Different result | Gives the percentage as a plain number like 75. Don't also apply the % format, or it shows 7500%. Shows 7500.0% and so on, because the % format multiplies by 100 again. |
Common mistakes
- Multiplying by 100 and applying the % format shows 7500%. Do one or the other.
- A format without decimals shows 18.75% as 19%. Add decimals with Increase Decimal.
- In formulas, write a percentage as 20% or 0.2. Typing 20 means 2,000%.
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 does my percentage show as a decimal
D2, calculate the share of tasks done; the cell is already formatted as a percentage. Fill down to D6.Questions
How do I put a percentage into text?
=TEXT(B2/C2,"0.0%") returns "75.0%" as text, ready to join into a label.
Why does my percentage show 0%?
The value is below 0.5% and the format has no decimals. Add decimal places.
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.