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.

    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.

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×