CREATE A CUSTOM NUMBER FORMAT

Prev Show Me Step-By-Step Next

Get Ready
If possible, identify a format that is similar to the one you want to create.
Select the cell or cells containing the numbers you want to reformat. Click here: GO if you don't know how to do this. Use the Back button on your Browser to return here when you're through.

Begin
Display the Format menu and then select the Cells command.
OR
Hold down the Ctrl key and then type 1.
In a few moments, the Format Cells dialog box will display. If necessary, click the Number tab.
Scroll down to the end of the Category list and click the word Custom.
In the Type box, select the format that is most similar to the one you want.
Example: 0.00%
Change the format to match your needs.
Example: 0.000%
Click the button.