Change the Number of Decimals Places in Google Sheets

When you enter a number in a cell or cells in Google Sheets that is formatted for a number, it rounds off the excess decimals to a set precision. By default, it is set to two decimal places:

*Original number with several decimal places rounded off to having only two decimal places.*

You can increase or decrease the number of decimal places displayed by Google Sheets.

Increase the number of decimal places displayed

To increase the number of decimal places displayed, select the cell or cells you want to change, then click the following icon in the toolbar above the sheet:

*The button for increasing the decimal places highlighted*

The result is:

*The set number with two decimal places increased to three decimal places*

If you try adding more decimal places than were originally included, zeros will be added:

*The number having more decimal places than the original number in the source cell has will have additional zeroes at the end of it.*

Decrease the number of decimal places

To decrease the number of decimal places displayed, select the cell or cells you want to change, then click the following icon in the toolbar above the sheet: