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.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.

## 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)`

- Drag the
**Fill Handle**to the range you need.

Here is the output of removing decimals using the** INT** function.

**Similar Readings**

**[Fixed] Excel Formula Bar Not Showing Cell Contents****How to Show and Hide Formula Bar in Excel (3 Methods)**

### 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

**Read More:** **[Fixed]: Formula Bar Shows Different Value Than Cell in Excel (3 Solutions)**

## 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.