How to Apply the Percent Number Format in Excel 2010

Many Excel 2010 worksheets use percentages in the form of interest rates, growth rates, inflation rates, and so on. When you apply the Percent Style format to a value that has already been entered in a cell, Excel multiplies the value by 100 and displays the result with a percent sign.

To insert a percentage in a cell as you are entering a value, type the percent sign (%) after the number. To indicate an interest rate of 12 percent, for example, you enter 12% in the cell. When you use this method, Excel assigns a Percent Style number format, divides the value by 100 (that’s what makes it a percentage), and places the result in the cell (0.12 in this example).

Not all percentages in a worksheet are entered by hand in this manner. Some may be calculated by a formula and returned to their cells as raw decimal values. In such cases, you should add a Percent format to convert the calculated decimal values to percentages.