Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

# How to Remove Decimals in Excel Formula Bar (5 Methods)

Excel provides a myriad of functions and options to remove decimals in the formula bar. In this article, I am going to discuss 5 easy of these methods.

## 5 Easy Ways to Remove Decimals in Excel Formula Bar

Let’s get introduced to the following dataset first which we are going to use in the demonstration of the methods. The dataset has some decimal numbers and we will remove the decimals. ### 1. Remove Decimals in Excel Formula Bar Using Decrease Decimal Button

To remove Decimals in Excel Formula Bar Using Decrease Decimal Button, execute the following steps.

📌 Steps:

• Select the range of cells or the entire column.
• Go to the Home tab > the Number group > Decrease Decimal button. You can click this button to reduce the number of decimal places until all your numbers have turned into integers.

Output:

Here is the output. ### 2. Eliminate Decimals in Excel Formula Bar with the Format Cells Dialog Box

We can also remove decimals using the Format Cells option. The following steps you need to follow:

📌 Steps:

• Select the range of cells that contain the numbers you want to remove decimals from. You can also select the entire column like us.
• Now, right-click your mouse, after that click on the Format Cells options from the context menu. It will open the Format Cells dialog box.

• Select Number from the Category drop-down. • On the right side, decrease the Decimal places count to 0 (zero). •  To turn off the dialog box, Click OK.

Your desired numbers are now rounded to their closest integers like the following output. ### 3. Exclude Digits after Decimal in Formula Bar with INT Function

The INT function rounds numbers down to the nearest integers. In this method, we will use the INT function to remove digits after decimal points from a number. Just follow the steps below.

📌 Steps:

•  Enter the following formula in Cell C5:
`=INT(B5)` Here is the output of removing decimals using the INT function. ### 4. Remove Digits after Decimal with TRUNC Function in Excel Formula Bar

The TRUNC function truncates numbers to integers by removing the decimals or fractional parts of the numbers. To remove digits after decimal points from a number using the TRUNC function, apply the following steps.

📌 Steps:

• Put the following formula in Cell C5:
`=TRUNC(B5)`
• Drag the Fill Handle to the range you need. Here is the output of removing decimals using the TRUNC function. While INT rounds the number down, then the  TRUNC simply truncates the decimal part.

### 5. Remove Decimals Using ROUND/ROUNDUP/ROUNDDOWN Function in Formula Bar

We can also remove decimals from the Excel formula bar using any of these functions: ROUND, ROUNDUP, and ROUNDDOWN.

#### 5.1 Use the ROUND Function to Remove Decimals

The ROUND function rounds a number to a specified number of digits. In this method, we will use the ROUND function to remove digits after decimal points from a number.

📌 Steps:

• Enter the following formula in Cell C5:

`=ROUND(B5,0)`

• Pull the Fill Handle to the range you need. Here is the output of removing decimals using the ROUND function. #### 5.2 Use the ROUNDUP Function to Remove Decimals

The ROUNDUP function rounds a number up, away from zero. To know how to remove decimals using this function, go through the following steps.

📌 Steps:

• Enter the following formula in Cell C5:

`=ROUNDUP(B5,0)`

• Drag the Fill Handle to the range you need. Here is the output of removing decimals using the ROUNDUP function #### 5.3 Use the ROUNDDOWN Function to Remove Decimals

Conversely, The ROUNDDOWN function rounds a number down, toward zero. 📌 Steps:

• Type the following formula in Cell C5:

`=ROUNDDOWN(B5,0)`

• Pull the Fill Handle to the range you need. Here is the output of removing decimals using the ROUNDDOWN function ## Conclusion

In this article, I showed you multiple ways to remove decimals from a number or several numbers in a column in Excel. I hope you found this tutorial beneficial to you. Keep using them and let us know if you have any more ways to do the task. Don’t forget to drop comments, suggestions, or queries if you have any in the comment section below.

## Related Articles #### Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts 