August 4, 2021

Increase or Decrease the Number of Decimals Places of Numbers in Google Sheets

Google Sheet spreadsheet
SECTIONS
  1. Increase the number of decimal places
  2. Decrease the number of decimal places

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.
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 button for increasing the decimal places highlighted

The result is:

The set number with two decimal places increased to three decimal places
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.
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:

The button for decreasing the number of decimal places highlighted.
The button for decreasing the number of decimal places highlighted.

The function will no longer work when you have removed all the decimal places:

The number has no more decimal places. The button doesn’t work when all the decimal places are removed.
The number has no more decimal places. The button doesn’t work when all the decimal places are removed.

Suscribe to get more data and analytics tips!

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.