How To Stop Google Sheets From Rounding – Complete Guide

Working on Google Sheets is fun and exciting with the presence of formulas and functions. But, a key constraint for beginners using Google Sheets is that the application automatically rounds off numbers. It can vary, but never as accurate as you expect it to be. If that sounds like your issue, too, we’ve got you covered. 

The steps to stop Google Sheets from rounding are as follows:

1. Choose the cell where the Google Sheet has automatically rounded the value. 
2. Double-click and enter the formula in the input bar: =TRUNC(Value,[Places])
3. To extend it to multiple cells in the same column, drag the tiny square on the bottom right of the cell when the cell is selected. 

In this article, let’s look at ways to stop Google Sheets from rounding values automatically. 

Before we get started with the article, if you are looking to learn more about apps like Notion, Todoist, Evernote, Google Docs, or just how to be more productive (like Keep Productive’s awesome Notion course), you should really check out SkillShare. Skillshare is an online learning platform with courses on pretty much anything you want to learn. To learn more about Skillshare and its vast library of courses and get 30% off, click the link below:

SkillShare – Online Learning Platform

How To Stop Google Sheets From Rounding

There are two methods to stop Google Sheets from rounding values present in cells. 

• Increasing decimals
• Truncating function

Formatting cells on a sheet is feasible and also easy.

Increasing Decimals

1. Select one or more cells to apply this function. 
2. Tap on the “Increase decimal place” tool present on the toolbar. 
3. You can tap the tool multiple times to increase decimal places. 

This approach allows you to add any number of values after decimals; the application doesn’t round the value.

Truncating Function

The truncating function is the most effective way to stop Google Sheets from rounding values on cells. 

1. Select the cell containing the value to be truncated. 
2. Double-click and then type the formula: =TRUNC(Value,[Places])
3. Replace the Value in the formula with the exact number (including decimals) and type the number of decimal places to be displayed.

Let’s say you have the number 1.58976. When you type the formula as =TRUNC(1.58976,2), the value automatically shows as 1.58. You can drag the pointer to other cells in the same column. 

My Recommended Office Gear

[amazon table=”17112″]

Why Is My Spreadsheet Rounding Up?

Google Sheets automatically rounds up some values for formatting reasons or when there are several numbers after the decimal point. The internal ROUNDUP function makes this operation feasible. 

If you’ve mistakenly stopped Google from rounding values, you can do one of the steps below. 

1. Remove the truncate formula typed on the input bar. 
2. Tap on Reduce decimals tool often based on the outcome you prefer. 
3. Use the ROUNDUP function on the required cell. This lets Google Sheets round the value to the nearest whole number. 

Final Thoughts

An excellent aspect of Google Sheets is that it’s possible to undo operations if you’ve done them by mistake. Whether you want to stop Google Sheets from rounding or reactivate the option, you can do both in a few clicks. 

Check Out Our YouTube Channel!

We have a YouTube channel now and we are working hard to fill it with tips, tricks, how-tos, and tutorials. Click the link below to check it out!

link to our YouTube page

Can’t Remember Your Passwords? You Need 1Password!

Do you use the same password for multiple sites? Do you have trouble remembering all your passwords? You should try 1Password! 1Password is secure and allows you to log in to sites and fill out forms securely with a single click. I use 1Password for all my passwords and it really makes managing all my passwords simple.

For more information on 1Password and to get a 14-day free trial, go to 1Password at the link below:

1Password – The world’s most-loved password manager