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


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


  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.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!