Number

To make it easier to read large numbers, enable the display of the digit group separator. A comma is used as the separator character. For example, the number 123456.00 with a separator is displayed as 123,456.00.

To separate groups of digits in numbers, follow these steps:

1.Select the cell or range of cells that contain the required numbers.

2.Run the command in one of the following ways:

•On the Toolbar, in the Number Format section, click  Use Thousands Separator.

•Open the number format settings window, select the Number format and select Use thousands separator.

•Press Ctrl+Shift+1.

If a format other than Number is applied to the selected cell, the following happens when the Use Thousands Separator option is selected:

•Сell format changes to Number.

•Digit groups are separated.

•Number of decimal places increases/decreases to two (default value).

The Use Thousands Separator button is always active. That means that before entering data into a cell, you can quickly apply the Number format to the cell and configure the display of the digit group separator.

The number of characters displayed in numbers after the decimal point can be reduced or increased. By default, two characters are displayed after the decimal point.

To do this, follow these steps:

1.Select the cell or range of cells that contain the required numbers.

2.Configure the display in one of the following ways:

•On the Toolbar, in the Number Format section, click Decrease Decimals or Increase Decimals.

•Open the number format settings window, select the Number format and specify the required Decimal Places using the counter.

When the number of characters decreases, the last visible digit is automatically rounded depending on the character to be hidden. Rounding is performed according to standard rules.

If the General, Date, Time, Date and time, Fraction or Text format, clicking Increase Decimals or Decrease Decimals will result in the following:

•Number format is applied to the cell.

•Number of decimal places increases/decreases relatively to the default value of two decimal places.

The Increase Decimals and Decrease Decimals buttons are always active. That means that before entering data into a cell, you can quickly apply the Number format to the cell and adjust the number of characters that will be displayed in numbers after the decimal point.

To customize negative number display style, follow these steps:

1.Select the cell or range of cells that contain the required numbers.

2.Open the number format settings window, select the Number format. In the Negative Numbers area, select the desired display format.