If you’ve worked with numbers in Google Sheets, you would’ve noticed that it rounds off your numbers. This can be useful at times but not at all times. If you’re wondering how to make Google Sheets stop rounding numbers, you’re at the right place.
2 ways to make Google Sheets stop rounding numbers
- By increasing the decimal places
- Using the TRUNC function
Method 1: By increasing the decimal places
This is one of the quickest ways to stop Google Sheets from rounding off your numbers.
Step 1: Highlight the desired cells.
Select the cells with the data you’d like to format so that they’re not rounded. For instance, cell B2 has only 8 decimal places, but you can see more decimals in the formula bar.
Step 2: Click on the increase decimal places option.
You can see the increased decimal places option in the toolbar. Click on it to increase it by one place. Depending on how many decimals you’d like to see, click on it that many times.
You can now see all the decimal places.
Note that if it exceeds the number of decimals, Google Sheets appends the number with zeros.
Method 2: Using the TRUNC function
You can use the Truncate function by Google Sheets to specify the number of decimal places you’d like to see. This would cut off the extra decimal places instead of rounding them off.
Step 1: Find the number of decimal places you’d like to see.
Here, you can see only 3 decimal places but let’s say you’d like to see the last 8 decimal places.
Step 2: Select a cell and type the function.
Select an empty cell to show the desired number without rounding it off. In that cell, you’ll have to enter the Truncate function. The syntax is =TRUNC(B2,8). The function takes in two parameters. The first one is the cell to truncate, and the second parameter is the number of decimal places you’d like to see.
Step 3: Press Enter.
After typing the function and its parameters, press Enter to see the function in action.
You can see that the value in cell C2 has been set to show 8 decimal places.
You can use any of the two methods above to avoid the automatic rounding off by Google Sheets. This will help you choose and display your desired number of decimals.