Split the number into digit groups

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 Home tab, in the Number format group, click  Use thousands separator.

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

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

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

•Cell 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.