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 in one of the following ways:

•In the Format menu, select Number format.

•On the Toolbar, select the Number Format section, display the list of available formats and select Advanced settings.

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

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

4.Specify the parameters for the format (see the description in the sections below).

5.Click ОК.

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