How To Make Google Sheets Not Round Up

Sometimes Google Sheets will round your numbers depending on the settings yous accept practical to your spreadsheet.

Sometimes this is a good affair, other times you may desire to run into the exact number without whatever rounding.

In this tutorial, I am going to show yous how to end Google Sheets from rounding your numbers.

Table of Contents

• 1 Why is Google Sheets Rounding?
• 2 How to Terminate Rounding Numbers in Google Sheets
  • 2.one Truncate
  • two.ii Increase Decimal Place Tool
• 3 Closing Thoughts

Why is Google Sheets Rounding?

By default, certain formats in Google Sheets will round numbers and simply brandish a sure amount of decimal places.

To set this, you lot tin try changing the format of your cells with a custom number format.

However, if you want to display the entire number without setting a custom format, use the method below.

How to Stop Rounding Numbers in Google Sheets

Truncate

The best fashion to finish Google Sheets from rounding your numbers is to utilise the Truncate function.

The Truncate role will show you lot all the decimal places in a value without any rounding.

The syntax of the Truncate function is:

=TRUNC(Value,[Places])

• Value is the number that you desire to use the formula on (a lot of times yous volition be using the cell reference where the value is located)
• Places indicate how many decimal places that you desire to show without rounding. If you want to show five decimal places, your second parameter in the formula would be five.

To apply truncate here's what you demand to exercise:

1. Select the prison cell that y'all desire the calculated value to exist and press the equals sign (=) on your keyboard to outset the function
2. Type "trunc" and printing Tab on your keyboard
3. Select the prison cell that has the value that you lot want to utilise in the formula, and so press the comma (,) button on your keyboard
4. Type the number for the number of decimal places you want to show (I showed 10 decimal places by placing a x hither)
5. Add a endmost parenthesis ")" and press Enter on your keyboard
6. If you want to perform the function on more than rows, copy and paste your formula down

This role can also exist used with other mathmetical calculations on role, for instance like this =TRUNC(A1+A2,ten)

Increase Decimal Place Tool

Another quick option that tin can be used to testify the full number is by selecting the Increase decimal places option in the toolbar.

To practice this:

1. Select the cells that yous want to show more than decimal places for
2. Click the Increase decimal place tool in the height menu.
3. Continue clicking on this tool until you reach the number of decimal places you lot want

<

Closing Thoughts

Fifty-fifty when Google Sheets is rounding numbers, the full value is even so there, it is only not shown. You tin can view the total number by using Truncate, manually selecting to view more decimal places, or by changing the number formatting to allow for more than decimal places.

More Google Sheets Tutorials:
How to Round Numbers
How to Add or Remove Dollar Sign
How to Turn Scientific Note On or Off
How to Keep Leading Zeros

Source: https://www.modernschoolbus.com/google-sheets-stop-rounding/

Share this post