How to Convert Decimal to Whole Number in Excel (10 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

In terms of working with Microsoft Excel, we need to work with numbers all the time. It is a common phenomenon that we might need the numbers into whole form rather in decimal form. We can simply convert the decimal to whole number. In this article, I am going to explain 10 simple ways on how to convert decimal to whole number in Excel. I hope it will be a very helpful article if you are looking for something like this.

For more clarification, I am going to use a dataset where I have enlisted top 10 T20I batsman based on average in Rank, Player, Team, and Average columns.

How to Convert Decimal to Whole Number in Excel


How to Convert Decimal to Whole Number in Excel: 10 Easy Ways

There are so many simple and effective ways to convert decimal to whole number in Excel. I am going to explain 10 of them in the following section.


1. Apply ROUND Function

ROUND Function is on the ways to convert decimal to whole number in Excel. The Round function rounds a number  up or down, depending on the specified number of digits and whether the number is positive or negative. If the number is positive, the Round function rounds the number down. If the number is negative, the Round function rounds the number up.

Steps:

  • Pick a cell and input the following formula.
=ROUND(E5,0)

Apply ROUND Function

  • Now, press the ENTER button to have the number in the whole form.

How to Convert Decimal to Whole Number in Excel


2. Adopt INT Function

The INT function rounds a number down to the nearest whole number. If the number is already an integer, the INT function doesn’t change it.

Steps:

  • Firstly, select a cell and input the following formula.
=INT(E5)

Adopt INT Function

  • Press ENTER.

  • AutoFill the rest cells.

 How to Convert Decimal to Whole Number in Excel


3. Use TRUNC Function

The TRUNC function in Excel is a mathematical function that returns a truncated number. This function is useful for removing decimal places from a number.

Steps:

  • Select a cell and write the following formula.
=TRUNC(E5,0)

 How to Convert Decimal to Whole Number in Excel

  • Hit ENTER to have the whole number.

  • Apply the above formula in the remaining cells using Fill Handle.

 How to Convert Decimal to Whole Number in Excel


4. Apply MROUND Function

The MROUND function in Excel returns a number rounded to a specified number of decimal places. This function is typically used to round numbers to a specified number of significant figures.

Steps:

  • Apply the formula written below to the selected cell.
=MROUND(E5,1)

  • Now, press the ENTER button to have the number in whole form.

 How to Convert Decimal to Whole Number in Excel

  • Use Fill Handle to AutoFill the rests.


5. Use FLOOR Function

The FLOOR function in Excel is a function that returns the smallest integer value that is less than or equal to a given number. It is useful for finding the next lowest whole number when dealing with decimal values. The floor function can be used on its own or as part of a larger formula.

Steps:

  • Pick a cell and input the following formula.
=FLOOR(E5,1)

  • To have the result, press ENTER.

 How to Convert Decimal to Whole Number in Excel

  • For the remaining cells, use AutoFill.

 How to Convert Decimal to Whole Number in Excel


6. Use CEILING Function

The CEILING function in Excel is a function that returns a number rounded up to the nearest integer multiple of a specified value.

Steps:

  • Select a cell and write the following formula.
=CEILING(E5,1)

 How to Convert Decimal to Whole Number in Excel

  • Press ENTER to have the output.

  • AutoFill the rests.

 How to Convert Decimal to Whole Number in Excel


7. Apply Decrease Decimal Command

We can also use the decrease decimal command from the ribbon under the Home tab.

Steps:

  • Select all the cells containing numbers first.
  • Go to Home.
  • From the Number group, click on the decrease decimal command based on your decimal numbers.

 How to Convert Decimal to Whole Number in Excel

We can have the converted numbers on the cells.


8. Utilize Built-in Number Format

There is also built-in format to convert the decimal number in the whole form. Just follow the following steps.

Steps:

  • First of all, select the cells.
  • Go to Home.
  • From the Number Format drop-down, select More Number Formats…

How to Convert Decimal to Whole Number in Excel

A wizard named Format Cells will appear.

  • Go to Number from Category.
  • Write 0 in Decimal places.
  • Then, click on OK.

We can see the converted decimal numbers on screen.

How to Convert Decimal to Whole Number in Excel


9. Apply EVEN Function

The EVEN function is a function that produces an output that is always an even number for any input value. It considers the higher value of the number.

Steps:

  • Firstly, select a cell and input the following formula.
=EVEN(E5)

  • Hit ENTER to have the whole number.

How to Convert Decimal to Whole Number in Excel

  • AutoFill the rest cells.

How to Convert Decimal to Whole Number in Excel


10. Use ODD Function

The ODD function converts the number into an odd number but not the lower one. It always converts into the upper odd number.

Steps:

  • Pick a cell and input the following formula.
=ODD(E5)

How to Convert Decimal to Whole Number in Excel

  • To have the result, press ENTER.

  • For the remaining cells, use AutoFill.

How to Convert Decimal to Whole Number in Excel


Practice Section

For more expertise, you can practice here.

For Practice


Download Practice Workbook


Conclusion

At the end of this article, I like to add that I have tried to explain 10 simple ways on how to convert decimal to whole number in Excel. It will be a matter of great pleasure for me if this article could help any Excel user even a little. For any further queries, comment below. You can visit our site for more articles about using Excel.


Related Articles

Naimul Hasan Arif
Naimul Hasan Arif

Hello, I am Arif. I am an Engineer who graduated from BUET. I want to pursue an enterprising career in a progressive environment where my skills & knowledge can be enhanced to their maximum potential to contribute to the overall success and growth of the organization.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo