Excel2010 Decimal or fractional set percentage number format

Step 1th, open the EXCEL2010 Worksheet window and select the cells that you want to set the percentage number format for. Right-click the selected cell and select Format Cells on the open shortcut menu, as shown in the following illustration.

Select Format Cells command

Step 2nd, in the Open Excel2010 Format Cell dialog box, switch to the Number tab. Select the percent option in the Category list and set the number of decimal places to keep in the decimal position spinner on the right. Set Complete Click the OK button, as shown in the following illustration.