HomeHow ToHow to Stop Google Sheets from Rounding your Numbers

How to Stop Google Sheets from Rounding your Numbers



We all know that rounding off numbers can help us solve mental equations faster. It is easier to solve 200 plus 500 than 248 plus 497. It helps when you buy things or want to know the value of something.

But, when you are dealing with accurate numbers, rounding off will not be as effective as creating mathematical decisions. Each number on the place values matters and can affect other numbers or the total.

Many users find it efficient to use Google Sheets when entering and organizing numbers in a worksheet. However, there are times when Google Sheets automatically rounds off the numbers. It is frustrating not to notice it and then realize the huge difference to your succeeding numbers.

When you do not want this to happen, you can stop Google Sheets from rounding your numbers. Follow the steps below to know how you can do it.

How to Tell Google Sheets to Stop Rounding your Numbers

Image / Windows Dispatch

Take note that Google Sheets follow the same mathematical rule when rounding off numbers. When the value is less than five, it retains the number on its left. When it is five to nine, it adds a number on its left.

To stop Google Sheets from rounding off your numbers, you will need to use the Truncate function. Using this function, it will show the decimal places without rounding off the number. All the values are retained even if you trim down your decimal places to two or add it up to five.

When using the Truncate function, you need to use this code: =TRUNC().

Inside the parenthesis should include the value of your number and the number of decimals, separated by a comma. For example, =TRUNC(23.765,3), where 23.765 is the value or amount that you want to show, and 3 is the number of decimal places.

Instead of the actual amount or value of the number, you can also use the cell location. For example, =TRUNC(C6,4), where C6 is the cell location of your number, and 4 is the number of decimal places.

Now, if you want to truncate the sum total of your number, add TRUNC before your Sum function. For example, =TRUNC(SUM(D2:D15,4).

Was the article helpful? Tell us in the comments below.


More From

How to Import Ques­tions to Google Forms

If you are looking for personalized answers online, creating a survey is an effective way to do it. By sending surveys to your friends...

How to Use Google Translate in Google Sheets

Google Translate is a helpful tool that works well when combined with many Google applications such as Chrome, Google Maps or even Google Sheets....

How to Create and Use Activities in Seesaw

Seesaw is an engagement platform that allows teachers to create activities and use them with their students remotely. Students can draw, write, send photos,...

How to Install Firmware Update to Surface Earbuds

Microsoft has just entered the true wireless earbuds (TWE) battle arena with the introduction of Surface Earbuds. This very competitive space is being shared...


  1. ”Now, if you want to truncate the sum total of your number, add TRUNC before your Sum function. For example, =TRUNC(SUM(D2:D15,4).”

    That functon is plain wrong, thanks for spreading misinformation.


Please enter your comment!
Please enter your name here

Recent Articles

Stay Connected