Create custom number formats

1. To format cells, click View Datasheet if you need to display the datasheet, and then select the cells for which you want to create a custom number format.

   How?

   To format a chart item, such as data labels or an axis, click the chart item you want.

   How?

2. On the Format menu, click Number.

3. In the Category box, click a category, and then select a built-in format that resembles the one you want.

4. In the Category box, click Custom.

5. In the Type box, edit the number format codes to create the format you want. Editing a built-in format does not remove it.