In this tutorial, we will learn How to stop Google Sheets from Rounding Numbers.
While working with google sheets you might have come across a situation where google sheets will round up your numbers on the sheet when you actually don’t need them.
Let’s try to find out How to make Google Sheets Stop Rounding Numbers
(How to get google sheets to stop rounding )
How to Stop Google Sheets from Rounding Numbers : Step by Step Guide.
Use the below methods to stop Google Sheets from rounding decimal numbers.
- By Using the TRUCN function
- Increasing the number of decimal places
#By Using the TRUCN function
To stop Google Sheets from rounding off your numbers, you can use the Truncate function which will truncate the input value to a specific number and remove the additional less significant digits.
Step 1: Decide how many decimal places should be visible
In the below example, Google Sheets has rounded off the number and only the last 8 decimal places are visible.
We decide to show only the last 4 Decimal places. Adjust as per your input value.
Step 2: Use the Truncate function.
Click on an empty cell where you want to see the desired truncated value.
- Type the below function in the function area fx .
- Two parameters are required for the function to work. The first parameter is the value in the cell to be truncated, and the second is the number of decimal places that you want to retain.
Adjust the Column and number value as per your requirement.
Step 3: Now press Enter.
After pressing enter you will see the desired value on your selected Column. In this example, you can see the result in Column C2 as shown below.
The truncate function has retained the last 6 decimal places.
#Increasing the number of decimal places
Using this method you can easily stop google sheets from rounding numbers.
Step 1: Select the desired cell with numbers.
Select the desired cell where you want the Google sheet to stop rounding.
Step 2: Select the increase/decrease decimal places option
Navigate to the Quick access menu where you will find the increase and decrease decimal places option.
- Right arrow sign – increase decimal places
- Left arrow sign – Decrease decimal places.
Keep Clicking on the increase decimal places arrow depending on your requirement.
Now all the decimal places are visible. Google sheets will append zeros at the end
We hope this tutorial on How to stop Google Sheets from Rounding Numbers was helpful.
Why is google sheets rounding my numbers ?
Google Sheets will allow only 10 digits in a cell including the decimal point, anything after that is rounded off by default
Related articles :
How To Transpose Data in Google Sheets
How to count non-empty cells in google sheets
How to insert Spin button in Google Sheets