Create custom number formats

  1. To format cells, click View Datasheet Button image if 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 Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.