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:
You can increase or decrease the number of decimal places displayed by Google Sheets.
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 result is:
If you try adding more decimal places than were originally included, zeros will be added:
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:
The function will no longer work when you have removed all the decimal places:
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.
.png)
