Excel XP
Formatting Numbers
Formatting Percentage 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 a Percentage in a Spreadsheet:
- Select a cell or range of cells.
- 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.
- Define the Decimal Places that will appear to the right of each number.
- Click the OK button.
