Microsoft Excel 2007 tutorial: format numbers as percentages

Format numbers as percentages

III. Format numbers as percentages

In Excel, you can display numbers as percentages by using Percentage format. You can format the numbers in a cell, range of cells, multiple nonadjacent cells, or ranges of cells all at once. To format the numbers, do the following:

- On the worksheet, select the cells, range of cell, multiple nonadjacent cells, ranges of cells that you want to format.

- On the Home tab, in the Number group, do one of the following:

  To format the numbers with default percentage (2-digit percentage format), click drop-down arrow of the Format Number box, and then click Percentage in the list.

  Excel 2007 Percentage format

 To format the numbers with percent symbol without the number of digits after the decimal, click Percent Style button Excel 2007 Percent Style button. Or you can use keyboard shortcut by pressing Ctrl +Shift +%.

  To display the numbers with percentage symbol that you can specify the number of decimal places, click drop-down arrow of the Number Format box, and then click More Number Formats. Or you can click Dialog Box Launcher.

  Excel 2007 More Number Formats  Excel 2007 Dialog Box Launcher

  In the Format Cells dialog box, on the Number tab, in the Category box, click Percentage. In the Decimal Places box, type or select the number of decimal places that you want to display; and then click Ok button to apply these formats.


-The numbers that are entered in the cells before you apply the Percentage format are multiplied by 100 to convert them to percentage. The numbers that are typed into the cells after you apply the Percentage format are treated differently. The numbers equal to or greater than 1 are converted to default percentages. And the numbers less than 1 are multiplies by 100 to convert them to percentages. For example, you type 20, the result will be 20%, and you type .2, the result will be 20% too.

- When you select the number in the active cell, it displays in the Sample box so that you can preview the number with the format options that you select.

- To change the default percentage in Microsoft Office Excel and other Microsoft Office application, you need to change the default regional number setting in Control Panel. Do the following:

(For window 7)

1. Click Start button, and then click Control Panel.

Excel 2007 Control Panel

2. Under Adjust your computer's setting, click Region and Language.

Excel 2007 Region and Language

3. In the Region and Language dialog box, click Additional Settings button.

4. In the Customize Format dialog box, click Number tab.

5. In the No. of digits after decimal combo box, select the number that you want.

6. Click Ok button.

- To reset the number format, do the following:

1. Select the cell, range of cells, multiple nonadjacent cells, ranges of cells.

2. Click General in the Number Format box, in the Number group of the Home tab or in the Category box, on the Number tab of the Format Cells dialog box.



This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.