Change the number format of datasheet cells or chart items

Applies To
Access for Microsoft 365 Access 2021 Access 2019 Access 2016 MS Graph 2003
  1. To format cells, click View Datasheet Button image if you need to display the datasheet, and then select the cells you want to change.
    How?
    To format a chart item, such as data labels or an axis, click the chart item you want to change.
    How?
  2. Click the button for the format you want.
    To select another format, click Number on the Format menu.
To display Click
Commas to separate thousands Comma Style
Button image
Currency symbol Currency Style
Button image
Numbers as percentages of 100 Percent Style
Button image
Fewer digits after the decimal point Decrease Decimal
Button image
More digits after the decimal point Increase Decimal
Button image