Sometimes, you need the data as it is but in a few cases, Google Docs round up the decimal numbers. In this article, we will discuss 2 simple approaches to stop Google Sheets from rounding up.
Table Of Contents
How to stop Google Sheets from rounding
Below are the 2 simple methods to do this.
- Approach-1: Change the formatting
- Approach-2: Use the Trunc function
Approach-1: Change the formatting
Follow the below steps, it is so simple.
- Select the cell for the one you wish to change the formatting and wish to keep the decimal number without rounding up.
- Press the Increase decimal places button from the toolbar as highlighted below. Each time you will press this button, it will increase one more decimal place. Note that Google Sheets will allow a maximum of 16 digits in one cell.
Approach-2: Use the Trunc function
The Trunc function can truncate a provided number to a specified number of digits without rounding up.
The syntax of the Truncate function in Google Sheets is as below
TRUNC(value, [places])Example:
If you are using the =TRUNC(15.07654,2), you will get the output as 15.07. and if you are using =TRUNC(15.07654,3), you will get the output as 15.076 as shown below.
To use the TRUNC function in Google Sheets, you need to follow the below steps.
- Select the cell where you wish to apply the TRUNC function.
- Type = and then followed by TRUNC (
3. Then you need to specify the arguments, First place you need to specify the value or the cell number that contains the number for Example in my case. it is B2 and then the second argument is the number of decimal places you wish to show. See the below screenshot.
You may also like following the below articles
Final Thoughts
In this article, we discussed, 2 simple ways to stop Google Sheets from rounding up. Thanks for reading this article !!!