Display numbers as fractions or percentages
- Select the cells you want to format.
- On the Format menu, click Cells, and then click the Number tab.
- Do one of the following:
- To display numbers as fractions, click Fraction in the Category list, and then click the type of fraction you want to use.
- To display numbers as percentages, click Percentage in the Category list. In the Decimal places box, enter the number of decimal places you want to display.
- To quickly display numbers as percentages of 100, click Percent Style on the Formatting toolbar.
Note Numbers above 1 are automatically entered as percentages; and numbers below 1 are converted to percentages by multiplying by 100. For example, entering 10 results in 10%, and entering .1 results in 10%. To have all numbers converted by multiplying by 100, on the Tools menu, click Options, click the Edit tab, and then clear the Enable automatic percent entry check box.