How to add or remove decimal places in Google Sheets

When you open a new spreadsheet in Google Sheets you’ll notice the numbers are formatted in a particular way. This is fine if you’re working on a basic spreadsheet and you want some quick results. However, there will be a time when you need to format the numbers to suit your project.

This article looks at all the different ways you can format numbers in Google Sheets. Most of the changes are pretty easy to do because Google Sheets comes with clickable icons that will do exactly what is needed.


By default, you’ll notice Google Sheets works with numbers in a specific way. In the example below I’ve entered five different numbers over five separate cells. You’ll notice some have two decimal points and others have none.

How to format numbers in Google Sheets

However, when I entered these numbers I used decimal points in all of the cells. Google Sheets, by default, only shows decimal places where it’s necessary. If the figure is a whole number no decimal places are used. This is fine because there is no value in showing decimal places that contain a zero amount.

You may, however, decide this does not look very appealing and may even cause some confusion. To fix this you need to format the numbers in the cells to show decimal places for all numbers whether rounded or not.


It’s really quick and simple to add or remove decimal places in Google Sheets.

Time needed: 1 minute

How to change the number of decimal points used in Google Sheets

  1. Highlight the range of cells

    First, you need to highlight the range of cells that you would like to format.highlight cells in Google Sheets

  2. Click on the icon showing the two decimal places from the toolbar

    On the default toolbar above your spreadsheet, you’ll find the icon that adds decimal points to the range of cells you’ve currently highlighted. You’ll notice the decimal places have now been used on the selected range of cells.
    How to add decimal points in Google Sheets

  3. How to remove decimal places

    If you wish to remove decimal places, you simply click on the icon shown below. This will remove a decimal place one at a time. Using both of these icons will allow you to set the exact number of decimal places you wish to use.

    The icon to use if you want to remove decimal places in Google Sheets