How to display a number as a percentage in Excel 2007

Don't know how to set a number as a percentage in Excel 2007? Do not worry, please see the introduction of this article:

1, select the cells you want to format.

2, on the Start tab, click the dialog Box Launcher next to number.

3, click Percent in the Category list.

4, in the Decimal places box, enter the number of decimal places to display.

Tips

• The number in the selected active cell on the worksheet appears in the sample box so that you can preview the selected number formatting options.

• To quickly display a number as a percentage, click percent in the Format number box or click Percent Style under Number on the Start tab.

Comments

• The number in the cell before you apply the percent format is converted to a percentage by multiplying 100来. The number you type in the cell after you apply the percent format is different. By default, numbers greater than and equal to 1 are converted to percentages, and numbers less than 1 are converted to percentages by 100来. For example, the result of typing 10 is 10%, and the result of typing. 1 is also 10%.

• To reset the number format of the selected cells, click General in the Category list. Cells formatted with the general format do not have a specific number format.