Create custom number formats

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?

On the Format menu, click Number.

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

In the Category box, click Custom.

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