How to stop Google Sheets from rounding

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. 
Increase decimal place tool
Increase decimal place tool

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.
Truncate formula
Truncate formula

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

Logitech MX Master 3 Advanced Wireless Mouse, Ultrafast Scrolling, Ergonomic, 4000 DPI, Customization, USB-C, Bluetooth, USB, Apple Mac, Microsoft PC Windows, Linux, iPad - Graphite
Keychron K2 Version 2 Wireless Gaming Mechanical Keyboard, Bluetooth/USB Wired Compact 84 Keys RGB LED Backlit N-Key Rollover Aluminum Frame for Mac Windows, Gateron G Pro Brown Switch
Elgato Stream Deck XL – Advanced Studio Controller, 32 macro keys, trigger actions in apps and software like OBS, Twitch, ​YouTube and more, works with Mac and PC
CalDigit TS4 Thunderbolt 4 Dock - 18 Ports, 98W Charging, 40Gb/s Thunderbolt 4, USB-A/C, 2.5GbE, 8K/6K Displays, Mac/PC/Chrome Compatible
Apple AirPods Max Wireless Over-Ear Headphones, Active Noise Cancelling, Transparency Mode, Personalized Spatial Audio, Dolby Atmos, Bluetooth Headphones for iPhone – Space Gray
BenQ ScreenBar Plus e-Reading LED Computer Monitor Light Bar with Desktop Dial, Auto-Dimming and Hue Adjustment, No Screen Glare, Space Saving, USB Powered, Matte Silver
Logitech MX Master 3 Advanced Wireless Mouse, Ultrafast Scrolling, Ergonomic, 4000 DPI, Customization, USB-C, Bluetooth, USB, Apple Mac, Microsoft PC Windows, Linux, iPad - Graphite
Keychron K2 Version 2 Wireless Gaming Mechanical Keyboard, Bluetooth/USB Wired Compact 84 Keys RGB LED Backlit N-Key Rollover Aluminum Frame for Mac Windows, Gateron G Pro Brown Switch
Elgato Stream Deck XL – Advanced Studio Controller, 32 macro keys, trigger actions in apps and software like OBS, Twitch, ​YouTube and more, works with Mac and PC
CalDigit TS4 Thunderbolt 4 Dock - 18 Ports, 98W Charging, 40Gb/s Thunderbolt 4, USB-A/C, 2.5GbE, 8K/6K Displays, Mac/PC/Chrome Compatible
Apple AirPods Max Wireless Over-Ear Headphones, Active Noise Cancelling, Transparency Mode, Personalized Spatial Audio, Dolby Atmos, Bluetooth Headphones for iPhone – Space Gray
BenQ ScreenBar Plus e-Reading LED Computer Monitor Light Bar with Desktop Dial, Auto-Dimming and Hue Adjustment, No Screen Glare, Space Saving, USB Powered, Matte Silver
-
Amazon Prime
Amazon Prime
Amazon Prime
Amazon Prime
Amazon Prime
Logitech MX Master 3 Advanced Wireless Mouse, Ultrafast Scrolling, Ergonomic, 4000 DPI, Customization, USB-C, Bluetooth, USB, Apple Mac, Microsoft PC Windows, Linux, iPad - Graphite
Logitech MX Master 3 Advanced Wireless Mouse, Ultrafast Scrolling, Ergonomic, 4000 DPI, Customization, USB-C, Bluetooth, USB, Apple Mac, Microsoft PC Windows, Linux, iPad - Graphite
-
Keychron K2 Version 2 Wireless Gaming Mechanical Keyboard, Bluetooth/USB Wired Compact 84 Keys RGB LED Backlit N-Key Rollover Aluminum Frame for Mac Windows, Gateron G Pro Brown Switch
Keychron K2 Version 2 Wireless Gaming Mechanical Keyboard, Bluetooth/USB Wired Compact 84 Keys RGB LED Backlit N-Key Rollover Aluminum Frame for Mac Windows, Gateron G Pro Brown Switch
Amazon Prime
Elgato Stream Deck XL – Advanced Studio Controller, 32 macro keys, trigger actions in apps and software like OBS, Twitch, ​YouTube and more, works with Mac and PC
Elgato Stream Deck XL – Advanced Studio Controller, 32 macro keys, trigger actions in apps and software like OBS, Twitch, ​YouTube and more, works with Mac and PC
Amazon Prime
CalDigit TS4 Thunderbolt 4 Dock - 18 Ports, 98W Charging, 40Gb/s Thunderbolt 4, USB-A/C, 2.5GbE, 8K/6K Displays, Mac/PC/Chrome Compatible
CalDigit TS4 Thunderbolt 4 Dock - 18 Ports, 98W Charging, 40Gb/s Thunderbolt 4, USB-A/C, 2.5GbE, 8K/6K Displays, Mac/PC/Chrome Compatible
Amazon Prime
Apple AirPods Max Wireless Over-Ear Headphones, Active Noise Cancelling, Transparency Mode, Personalized Spatial Audio, Dolby Atmos, Bluetooth Headphones for iPhone – Space Gray
Apple AirPods Max Wireless Over-Ear Headphones, Active Noise Cancelling, Transparency Mode, Personalized Spatial Audio, Dolby Atmos, Bluetooth Headphones for iPhone – Space Gray
Amazon Prime
BenQ ScreenBar Plus e-Reading LED Computer Monitor Light Bar with Desktop Dial, Auto-Dimming and Hue Adjustment, No Screen Glare, Space Saving, USB Powered, Matte Silver
BenQ ScreenBar Plus e-Reading LED Computer Monitor Light Bar with Desktop Dial, Auto-Dimming and Hue Adjustment, No Screen Glare, Space Saving, USB Powered, Matte Silver
Amazon Prime

Why Is My Spreadsheet Rounding Up?

Round up function
Round up function

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

Similar Posts