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.


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.

Remove Decimals in Excel Formula Bar with the Format Cells Dialog Box

It will open the Format Cells dialog box.

  • Select Number from the Category drop-down.

Remove Decimals in Excel Formula Bar with the Format Cells Dialog Box

  • On the right side, decrease the Decimal places count to 0 (zero).

Remove Decimals in Excel Formula Bar with the Format Cells Dialog Box

  •  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)

Remove Digits after Decimal with INT Function in Formula Bar

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

Output: Remove Digits after Decimal with INT Function in Formula Bar


Similar Readings


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.

Remove Digits after Decimal with TRUNC Function in Excel Formula Bar

Here is the output of removing decimals using the TRUNC function.

Output: Remove Digits after Decimal with TRUNC Function in Excel Formula Bar

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.

Remove Decimals Using ROUND Function in Formula Bar

Here is the output of removing decimals using the ROUND function.

Output: Remove Decimals Using ROUND Function in Formula Bar

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.

Remove Decimals Using ROUNDUP Function in Formula Bar

Here is the output of removing decimals using the ROUNDUP function

Output: Remove Decimals Using ROUNDUP Function in Formula Bar

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.

Remove Decimals Using ROUNDDOWN Function in Formula Bar

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.


Related Articles

Hafiz Islam
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo