How to add or remove decimal places in Google Sheets
Commission may be earned if you purchase through links on this site - learn more
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.
DEFAULT FORMAT OF NUMBERS IN GOOGLE SHEETS
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.
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.
HOW TO ADD OR REMOVE DECIMAL PLACES IN GOOGLE SHEETS
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
- Highlight the range of cells
First, you need to highlight the range of cells that you would like to format.
- 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 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.