Open number format settings window

Use the Number format window to customize the display of data in cells for which the format Number, Currency, Accounting, Date and/or Time, and Percentage is selected.

To customize the formats, follow these steps:

1.Select the cell/range or rows/columns where you want to customize the data display.

2.Open the Number format settings window using one of the following methods:

•On the Home tab, in the Number format group, expand the list of formats and select Options.

•When working in macOS, select Format > Number format command from the command menu.

•Right-click the selected cells or the titles/contents of the selected rows/columns to open the context menu. Select Number format from the context menu.

•Press Ctrl+1 (Windows, Linux) or  Cmd+1 (macOS).

3.In the Number format window, select the format you want to customize from the list to the left.

4.Specify the parameters of this format. A detailed description of the parameters is provided in the sections below.

5.Click OK.

To navigate through the Number format window, use the Tab button (to move from left to right) or the Shift+Tab shortcut (to move from right to left). If a list is selected, use the ↓ and ↑ buttons to navigate through it.