Create custom number formats

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 MS Graph 2003 More...Less

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.