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 Home tab, in the Number format group, click editor_delete_zero_icon Decrease decimals or editor_add_zero_icon 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 editor_add_zero_icon Increase decimals or editor_delete_zero_icon 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 editor_add_zero_icon Increase decimals and editor_delete_zero_icon 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.

Was this helpful?

Yes