Hafiz Islam
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.
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.
