ThisCalculator

Everyday

Excel Add Percentage Sign: 4 Easy Ways

Updated · Standard formula, shown below

To add a percentage sign to numbers in Excel, you can apply the built-in Percent Style button, use the Format Cells dialog, or multiply by 100 and append the symbol with a custom format. The method you choose depends on whether you want the cell to remain a true numeric percentage or display a text symbol.

Why the Percentage Sign Matters in Excel

Excel treats percentages as fractions of 1. For example, 50% is stored as 0.5. This design makes calculations straightforward—multiplying a price by 0.5 gives a 50% discount—but it confuses many users who type 50% and expect to see 50% in the cell. When you type 50%, Excel automatically applies the percent format and stores 0.5. However, if you type 50 and then want the percent sign to appear, you must format the cell—otherwise Excel will show 50 or, worse, 5000% if you apply the percent format without adjusting the value.

Method 1: The Percent Style Button

The fastest way to add a percentage sign is the Percent Style button in the Number group on the Home tab (it looks like %). Select the cells, then click the button. Excel multiplies the values by 100 and adds the percent sign—so 0.5 becomes 50%. If your cells already contain 50 (not 0.5), clicking Percent Style will display 5000% because Excel assumes you meant 50 = 5000%. To fix this, either divide the values by 100 first or use a custom format as described below.

Method 2: Format Cells Dialog

For more control, use the Format Cells dialog:

  1. Select the cells.
  2. Press Ctrl+1 (Windows) or Cmd+1 (Mac).
  3. Go to the Number tab, choose Percentage.
  4. Set the number of decimal places (e.g., 0 for whole percentages).
  5. Click OK.

This does the same as the Percent Style button but lets you control decimals. For example, 0.256 with 1 decimal place becomes 25.6%.

Method 3: Custom Format to Keep the Value Intact

If you have numbers like 50 and you want them to display as 50% without changing the underlying value, use a custom number format:

  1. Select the cells.
  2. Press Ctrl+1.
  3. Choose Custom at the bottom of the category list.
  4. In the Type box, enter 0"%" (for whole numbers) or 0.0"%" for one decimal.
  5. Click OK.

Now 50 displays as 50%, but the cell value remains 50. This is ideal when you are working with data that is already a percentage number (like 50 meaning 50%) and you don’t want to divide by 100. Note that this custom format does not make the value usable in calculations as a true percentage (0.5). If you multiply 50 by a price, you get 50 times the price, not half the price.

Method 4: Convert Text to a Percentage

Sometimes you need a text string like 50% for labels or reports. You can use a formula:

  • To add a percent sign to a number in another cell: =A1&"%" (if A1 contains 50). This creates text, so you cannot use it in arithmetic.
  • To convert a decimal to a text percentage: =TEXT(A1,"0%") where A1 contains 0.5. This yields 50% as text.

Be careful: text percentages cannot be summed or multiplied. Use them only for display.

Common Mistakes and How to Avoid Them

The most frequent error is applying Percent Style to numbers that are already whole percentages. For example, if a column shows 50 (meaning 50%), clicking Percent Style gives 5000%. To fix, either divide the range by 100 before formatting, or use the custom format 0"%" to preserve the value.

Another mistake is confusing the percent format with the percentage change formula. Adding a percent sign to a cell does not calculate a percentage change. If you want to show a change from 20 to 25 as 25%, you need to compute =(25-20)/20 and format the result as a percentage.

Rounding can also surprise you. If you format 0.666 as a percentage with 0 decimals, Excel displays 67% (rounded), but the underlying value remains 0.666. If you later use that cell in a formula, you get the precise value, not the rounded one. To make the displayed value the actual value, you can use the ROUND function, but that changes the data.

Frequently Asked Questions

Why does Excel show 5000% when I click the percent button?

Because Excel multiplies the cell value by 100 to convert a decimal to a percentage. If your cell contains 50 (not 0.5), 50 × 100 = 5000. To fix, divide the numbers by 100 first, or use a custom format 0"%" to just add the sign.

How do I add a percentage sign without changing the value?

Use a custom number format: select the cells, press Ctrl+1, choose Custom, and type 0"%" (or 0.0"%" for decimals). This displays the percent sign but keeps the cell value exactly as entered.

What is the difference between typing 50% and formatting 0.5 as a percentage?

Typing 50% tells Excel to store 0.5 and display 50%. Formatting 0.5 as a percentage also displays 50% but the underlying value is 0.5. Both are numerically identical; the only difference is how you entered the data.

Can I add a percent sign to a whole column at once?

Yes. Select the entire column (click the column letter), then apply any of the methods above. For the custom format, the format will apply to all cells in the column, even empty ones, which is fine.

How do I show percentages in Excel charts?

Charts automatically use the number format of the underlying data. If your cells are formatted as percentages, the chart axis and data labels will show the percent sign. If not, right-click the axis or labels, choose Format Axis or Format Data Labels, and set the number format to Percentage.

What if I want to remove the percentage sign but keep the value?

To remove the percent sign and keep the numeric value (e.g., 50% becomes 50), apply the General format. However, the underlying value is 0.5, so it will display as 0.5. To get 50, you need to multiply by 100: put =A1*100 in a new cell and copy it as values.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.