If you’ve worked with numbers in Google Sheets, you would’ve noticed that it rounds off numbers by default.
However, it is also possible to configure google sheets so that it stops rounding numbers. Here are a couple of ways to do it.
2 ways to make Google Sheets stop rounding numbers
- Using Increasing Decimal Places option in the Toolbar
- Using the TRUNC function
Method 1: Using “Increasing Decimal Places” option in the Toolbar
This is one of the quickest ways to stop Google Sheets from rounding off your numbers.
Step 1: Highlight the desired cells.
For instance, cell B2 has only 8 decimal places, but you can see more decimals in the formula bar.
Select cell B2.
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 to cut off the extra decimal places instead of rounding them off. Here is how you can do it.
Step 2: Use the TRUNC Function
Here, you can see only 3 decimal places but let’s say you’d like to see the last 8 decimal places.
You can use the TRUNC function to do that.
Select an empty cell to use the formula. Here we will use cell b
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.
Pressing entering will display the output of the formula.
You can see that the value in cell C2 has been set to show 8 decimal places.
Wrapping up
You can use any of the two methods above to avoid the automatic rounding off by Google Sheets.