How to Remove Decimal Point in Excel Without Rounding

Are you interested in learning how to remove decimal point in Excel without rounding?

Dealing with large data sets that include decimal numbers can sometimes make it difficult to read.

Usually, Excel rounds off those decimals to the nearest whole number.

However, what if you want to keep the number as it is, without rounding?

You want Excel to ignore everything after the decimal point, turning it into a whole number.

Luckily, there are multiple ways to achieve this.

In this article, we’ll walk you through the simplest method to remove decimal point in Excel without rounding.

Also read: (opens in new tab)
Adding Multiple Cells in Excel
Quick Analysis Tool Excel Not Showing Up Mac
How to Change Legend Text in Excel

How to Remove Decimal Point in Excel Without Rounding

Step 1: Click on a blank cell

To start, choose an empty cell where you’d like to view the number without the decimal.

Step 2: Enter this formula “=TRUNC()”

Now, type the formula =TRUNC() into the selected cell.

Step 3: Enter the cell number into the formula and press enter key

Inside the brackets of the formula, input the cell reference, such as “D3,” which corresponds to the specific cell you want to work with.

For instance, if you wish to remove the decimal point from the third cell in column “D,” enter “D3” within the brackets of the formula, and then press the Enter key.

Step 4: Drag the cell to apply the same formula to other cells

Now that you have successfully removed the decimal from the number in the initial cell, it is time to extend this change to the other numbers in the same column.

You don’t need to manually enter the formula in every cell.

Instead, use this shortcut method:

Click on the cell containing the formula.

You’ll notice a small square box in the bottom right corner of that cell.

Click and hold on this box, then drag it downward to apply the same formula to the remaining cells below.

This way, the same operation will be automatically applied to all the cells below, saving you time and effort.

Prevent Automatic Rounding in Excel

If you find that Excel is rounding your numbers automatically, you can prevent this by following these steps:

1. Select the Column: Start by choosing the column (or columns) containing the numbers you want to modify.
2. Right-Click: Next, right-click anywhere within the selected column.
3. Choose “Format Cells…”: From the menu that appears, select the “Format cells…” option.
4. Navigate to the “Number” Tab: Select the “Number” tab.
5. Select “Number” Category: Within the “Number” tab, choose the “Number” category from the options.
6. Set Decimal Places: Locate the “Decimal places” field and enter the number of digits you want to appear after the decimal point. For example, if you want to see two digits after the decimal point, type “2” in this field.
7. Confirm Changes: Finally, press the “OK” button to apply your settings.

Conclusion

Removing decimal points in Excel without rounding is an easy task that can be achieved in just a few steps. Here’s how to remove decimal point in Excel without rounding:

1. Click on a blank cell.
2. Enter the formula “=TRUNC()”.
3. Enter the cell reference inside the brackets of the formula and press the Enter key.
4. Drag the cell to apply the same formula to other cells.