You have a decimal number like 0.15 in an Excel cell, but you need it to appear as 15%. The cell’s number format controls how a value is displayed without changing its underlying value. This article explains how to apply the Percentage number format using several methods.
Key Takeaways: Formatting Numbers as Percentages in Excel
- Home > Number > Percent Style button: Applies a default percentage format with zero decimal places to selected cells.
- Ctrl+Shift+% keyboard shortcut: Instantly applies the default percentage format to the active cell or selection.
- Format Cells dialog (Ctrl+1): Provides full control over decimal places and other formatting options for percentages.
Understanding Excel’s Percentage Format
Excel’s Percentage format multiplies a cell’s value by 100 and displays it with a percent symbol. The number 0.85 becomes 85%, and 1 becomes 100%. This format only changes the visual presentation. The actual stored value remains the decimal number, which is critical for accurate calculations.
A common point of confusion is data entry. If you type 15 into a cell already formatted as a percentage, Excel interprets it as 15% and stores 0.15. To enter 15% correctly, you can type 15% or 0.15. The format is best applied after entering raw decimal values to avoid calculation errors.
How Excel Calculates Percentages
The percentage format is a display layer. When you format 0.1 as a percentage showing 10%, Excel still uses 0.1 in formulas. If you multiply that cell by 100, the result is 10, not 1000. This behavior ensures formulas reference the correct underlying data.
Methods to Apply Percentage Formatting
You can format cells as percentages using the ribbon, a keyboard shortcut, or a detailed dialog box. The method you choose depends on whether you need speed or precise control over decimal places.
Using the Ribbon Button
- Select the target cells
Click and drag to select the cell or range containing your decimal numbers. - Navigate to the Home tab
Go to the Home tab on the Excel ribbon. - Click the Percent Style button
In the Number group, click the % icon. This applies the default percentage format with no decimal places.
Using the Keyboard Shortcut
- Select the cells to format
Use the mouse or arrow keys to highlight the relevant cells. - Press Ctrl+Shift+%
Hold the Ctrl and Shift keys, then press the percent key. This performs the same action as the ribbon button.
Using the Format Cells Dialog for Precision
- Select your cells and open the dialog
Select the cells and press Ctrl+1, or right-click and choose Format Cells. - Choose the Percentage category
In the Format Cells dialog, click the Number tab. Select Percentage from the Category list. - Set the decimal places
Use the Decimal places spinner to choose how many digits appear after the decimal point, such as 2 for 15.25%. - Apply the format
Click OK. The selected cells will now display with the percent symbol and your chosen decimal precision.
Common Formatting Mistakes and Limitations
Applying percentage formatting seems simple, but specific errors can lead to incorrect data.
Entering Whole Numbers into Pre-formatted Cells
If you format an empty cell as a percentage and then type 5, Excel stores 0.05. This causes major calculation errors. The fix is to enter the value as a decimal first. Type 0.05 or 5%, then apply the format, or apply the format after typing the number 5 and then edit the cell to 500%.
Percentage Format Not Applying to All Cells
Sometimes, clicking the % button only affects some cells in a selection. This happens if the range contains cells with different existing formats, like Text. Select each problematic cell individually. Clear its format via Home > Editing > Clear > Clear Formats. Then reapply the Percentage format.
Percentages Displaying Too Many Decimal Places
The ribbon button shows zero decimals. If you see many decimal places, the cell likely has a Custom or General format overriding it. Use the Format Cells dialog (Ctrl+1) to set the Percentage category and explicitly define the decimal places.
Calculations Showing 0% or 100% Incorrectly
A formula result might show as 0% when you expect a small number like 0.5%. This occurs if the cell is formatted with zero decimal places, as 0.5% rounds to 1%, not 0%. Increase the decimal places using the Increase Decimal button in the Home tab’s Number group or the Format Cells dialog.
Percentage Format vs. Other Number Formats
| Item | Percentage Format | General or Number Format |
|---|---|---|
| Display of 0.15 | 15% | 0.15 |
| Underlying Stored Value | 0.15 | 0.15 |
| Data Entry of “15” | Stores as 0.15 | Stores as 15 |
| Primary Use Case | Displaying ratios and proportions | Displaying raw decimal numbers |
| Calculation Behavior | Uses decimal value (0.15) | Uses displayed value (0.15) |
You can now correctly display decimal numbers as percentages in Excel. Use the Percent Style button for speed or the Format Cells dialog for control over decimals. For advanced use, try creating a custom number format like “0.0%” to always show one decimal place, even when using the keyboard shortcut.