Formatting a percentage

To format a number to be displayed as a percentage:

  1. Select the Cells command from the Format menu (or right-click and select Format Cells).

  2. Select the Number tab in the "Format" dialog box.

  3. Select Percent from the numbers list. The "Percent" group box will be displayed.

  4. The percentage symbol will be attached to the number. The rest of the percentage options are the same as for the Number format - see Formatting a number for details on how to set these.

Note: you can also use the Percentage button image\percent.gif on the formatting toolbar to apply percentage formatting.