If you have been using Google Sheets for a while, you probably have noticed that, by default, the program rounds up numbers. For example, if you enter 2.678, Google Sheets will display 3. This can be problematic for those who need exact numbers for their calculations.
Today, we’ll show you a simple way to prevent Google Sheets from rounding up your numbers. Let’s get started!
Using the Format option
The easiest way to prevent Google Sheets from rounding up numbers is to use the Format option.
Follow these steps:
- Select the cells you want to format.
- Click on Format in the menu.
- Hover over Number.
- Click on More Formats at the bottom of the drop-down.
- Select Custom number format.
- Enter the number of decimal places you want in the format. For example, if you want two decimal places, you’d enter 0.00.
- Press Apply.
Using a Formula
If you want to use a formula to prevent rounding up, the TRUNC function is your best bet.
Here’s how to use it:
In the cell where you want the truncated number to appear, type =TRUNC( followed by the cell number that contains the number you want to truncate and the number of decimal places you want. Then, close the parenthesis.
In this example, A1 is the cell with the number you want to truncate, and 2 is the number of decimal places you want.
And that’s it! With these tips, you can easily prevent Google Sheets from rounding up your numbers. Happy calculating!