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.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×