Formatting Numbers

Formatting Excel numbers can improve how your spreadsheet looks. Use the number function in Excel to also better organize content.

Formatting percentages in the Format Cells dialog box

There may be times you want to display certain numbers as a percentage. For example, what percentage of credit cards bills account for your total monthly expenses?

To express numbers as percentages in a spreadsheet:

  • Select a cell or range of cells.

    Define Cell Range for Percentage Function
  • Choose Format Cells from the menu bar.
  • The Format Cells dialog box opens.
  • Click the Number tab.
  • Click Percentage in the Category drop-down list.

    The Number Tab on the Format Cells Dialog Box
  • Define the Decimal Places that will appear to the right of each number.
  • Click the OK button.

    Percentage Applied to Cell Range