Excel Percentage Number Format: How It Works

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the cells and choose Home > Number > Percent Style to display their values as percentages. Percentage formatting changes how a number appears, not the value stored in the cell: for example, 0.25 displays as 25%.

What percentage number format means

A percentage is a number expressed as a fraction of 100. Excel’s Percentage number format displays a value multiplied by 100 and adds a percent sign. The underlying value stays the same, so changing a cell from General to Percentage is a display operation rather than a calculation.

This distinction matters because Excel stores percentages as decimal numbers. The value 0.08 represents eight percent, while 1 represents 100 percent and 1.5 represents 150 percent. A cell formatted as Percentage displays those values as 8%, 100%, and 150% respectively.

Percent formatting is useful for rates, proportions, completion, discounts, and shares of a total. It makes a decimal easier to interpret, but it does not decide whether a result is sensible. A percentage above 100% may be perfectly valid, such as growth from a small starting value; a negative percentage may represent a decline.

How to apply Percentage format

For a quick format in Excel for Microsoft 365 on Windows, select one or more cells and use Home > Number > Percent Style. The selected values display as percentages, usually with no decimal places by default. The same Percent Style control is available on the Home tab in Excel for Mac; the ribbon layout can vary slightly with window size.

You can also use the keyboard shortcut Ctrl+Shift+% on Windows. It applies Percentage format with zero decimal places. On a Mac, use the Percent Style button if the shortcut differs on your keyboard layout or does not work in your Excel setup.

To set the number of decimal places or confirm the format settings:

  1. Select the cells, then press Ctrl+1 on Windows to open Format Cells. On a Mac, use Command+1.
  2. Choose the Number tab, then select Percentage in the Category list.
  3. Set Decimal places to the precision you need and select OK.

You can also use the Increase Decimal and Decrease Decimal controls in Home > Number to adjust displayed precision after applying the format. These controls change what is shown, not the underlying number.

What Excel stores when you enter a percentage

Typing a number with a percent sign is different from typing the same digits without one. If you type 12% into a cell, Excel interprets it as 0.12. If you type 12 and then apply Percentage format, Excel displays 1200%, because the stored value is 12. This is one of the most common causes of unexpectedly large percentages.

For example, enter 0.4 and apply Percentage format to display 40%. Alternatively, type 40% directly and Excel stores 0.4. But if you already have a value of 40 and want it to mean 40%, simply formatting it will not convert it to 0.4. You need to change the value, for example by dividing it by 100, or re-enter it as 40%.

To check what a cell contains, select it and look at the formula bar. The cell may display 40%, while the formula bar shows 0.4. That is expected: the cell uses a readable display format while the formula bar exposes the stored number.

Choose the right number of decimal places

Decimal places help readers distinguish values that would otherwise round to the same whole percent. A rate of 0.124 displayed with no decimals appears as 12%, while one decimal place shows 12.4% and two places show 12.40%. The stored value remains 0.124 in all three cases.

Choose precision based on the purpose of the data, not just the available screen space. Whole percentages are often adequate for a brief status summary. A report comparing close rates or small proportions may need one or two decimal places. Showing many decimals can make a table harder to scan and suggest a level of certainty the source data does not support.

Excel rounds the display to the chosen precision; it does not round the stored value. For instance, 12.46% displayed with one decimal place appears as 12.5%, but calculations still use the stored value behind that display. If you truly need to round the value used in later calculations, that is a separate calculation step, not a number-format setting.

Calculate a percentage with a formula

When you want a proportion such as completed items divided by all items, calculate the fraction first and format the result as a percentage. With the total in A2 and the completed count in B2, enter this formula in C2:

=B2/A2

If A2 contains 80 and B2 contains 25, the formula returns 0.3125. Apply Percentage format to C2 and it displays 31.25% with two decimal places. The arithmetic is 25 divided by 80, or 0.3125; displaying that fraction as a percentage gives 31.25%.

Make sure the denominator is the total that answers the question you intend to ask. Dividing completed tasks by all assigned tasks is different from dividing them by tasks due this week. Also consider what should happen if the denominator is zero or blank; division by zero produces an error, so the input data or the formula may need a deliberate zero-case rule.

Percentage change is not the same as percentage points

Percentage format can display both a percentage level and a percentage change, but those describe different things. If a rate rises from 40% to 50%, the increase is 10 percentage points. Relative to the original 40%, it is a 25% increase. Saying only “up 10%” can therefore be ambiguous.

With the original value in A2 and the new value in B2, enter the following formula in C2 to calculate relative percentage change:

=(B2-A2)/A2

If A2 is 40% and B2 is 50%, Excel stores them as 0.4 and 0.5. The formula returns 0.25, which displays as 25%. The percentage-point difference is instead 50% minus 40%, or 10 percentage points. State clearly which measure a table or chart is showing, especially when comparing rates over time.

Common percentage-format problems

If a result looks wrong, check the stored inputs and the calculation before changing the format. A number format can make a value easier to read, but it cannot repair a mistaken input or incorrect denominator. These checks resolve many typical surprises:

  • The display is 100 times too large: A value such as 25 may have been entered when Excel needed 25%. Enter 25% or use 0.25 for a 25% rate.
  • The result shows no decimal places: Increase the displayed precision with Home > Number > Increase Decimal or set Decimal places in Format Cells.
  • The formula returns a decimal: The calculation may be correct; apply Percentage format to the result cell.
  • The result is negative or above 100%: Check the inputs and meaning. These values are not automatically errors, though they may be unexpected for a particular measure.
  • The total appears to be 99% or 101%: Rounded displayed percentages may not add to exactly 100%. The underlying values may sum to 100% even when rounded displays do not.

When percentages are added in a summary, avoid assuming that the formatted cells themselves explain the total. A share-of-total column should generally be calculated from each part divided by the same overall total. Adding percentages with different denominators can produce a mathematically correct sum that does not answer a meaningful question.

Percentage format, formulas, and custom formats

Use Percentage number format when you want a decimal value to be displayed as a percent without changing its stored value. Use a formula when you need to calculate a rate, difference, or change. These tools often work together: a formula calculates a fraction, and number formatting presents it clearly.

A custom number format is useful when the standard Percentage category does not provide the exact display you want. In Format Cells, choose Custom and create a pattern such as 0.0% for one decimal place. For most ordinary work, the built-in Percentage category is simpler and easier for other people to understand. Custom formats affect presentation too; they do not convert the underlying value.

There is also a difference between the number in a cell and text that merely looks like a percentage. A value formatted as Percentage remains numeric and can be used in arithmetic. Text such as 25% stored as text may not behave like the numeric value 0.25 in formulas, charts, or sorting. If a percentage will be calculated or analyzed, keep it numeric and apply a number format rather than building the percent sign into a text string.

Frequently Asked Questions

Does Excel percentage format multiply the cell value by 100?
It displays the value as if multiplied by 100, but does not change the stored value. A stored 0.2 remains 0.2 and displays as 20%.

How do I show two decimal places in a percentage?
Select the cells and set Decimal places to 2 in Format Cells > Number > Percentage. You can also use Increase Decimal on the Home tab until two places appear.

Why does 5 show as 500% in Excel?
Because Excel treats 5 as five whole units, and Percentage format displays five as 500%. If you mean five percent, enter 5% or 0.05.

Can a percentage be more than 100%?
Yes. A stored value greater than 1 displays above 100%. This can be appropriate for a ratio, an over-target result, or growth relative to a small starting value.

Why do percentages in my column add up to 99%?
Displayed values may have been rounded. Check the underlying decimals and the formula used for each share; the unrounded values can sum to 100% even if their rounded displays do not.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.