# How to Convert a Decimal to a Whole Number in Excel (10 Methods)

## Dataset Overview

We’ll use a dataset containing the information on the top 10 T20 batsmen based on average.Â  The dataset has columns for Rank, Player, Team, and Average.

### Method 1 – ROUND Function

The Round function rounds a number up or down, depending on the specified number of digits and whether the number is positive or negative.

• Enter the following formula in a cell to round a decimal number to the nearest whole number:
`=ROUND(E5,0)`

• Press ENTER.Â

• If the number is positive, it rounds down; if negative, it rounds up.
• Autofill the rest of the cells.

### Method 2 – INT Function

The INT function rounds down to the nearest whole number.

• Enter the following formula in a cell and press ENTER:
`=INT(E5)`

• Autofill the remaining cells.

### Method 3 – TRUNC Function

TRUNC removes decimal places without rounding.

• Select cell B5 and insert the following formula:
`=TRUNC(E5,0)`

• Press ENTER

• Apply the formula to other cells using the Fill Handle.

### Method 4 – MROUND Function

MROUND rounds to a specified number of decimal places.

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

• Press ENTER.

• Autofill the rest.

### Method 5 – FLOOR Function

FLOOR returns the smallest integer less than or equal to a given number.

• Pick a cell and enter the following formula:
`=FLOOR(E5,1)`

• Press ENTER.

• Autofill the remaining cells.

### Method 6 – CEILING Function

CEILING rounds up to the nearest integer multiple of a specified value.

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

• Press ENTER.

• AutoFill the rests.

### Method 7 – Decrease Decimal Command

• Select cells with decimal numbers.
• Go to Home > Number group > Decrease Decimal.
• The numbers will be converted.

### Method 8 – Built-in Number Format

• Select cells.
• Go to Home > Number Format > More Number Formatsâ€¦

• In the Format Cells wizard, choose NumberÂ and set decimal places to 0.
• Press OK.

### Method 9 – EVEN Function

Produces even numbers.

• Select a cell and input the following formula:
`=EVEN(E5)`

• Press ENTER.

• AutoFill the rest cells.

### Method 10 – ODD Function

Converts to the next higher odd number.

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

• Press ENTER.

• AutoFill the formula to the other cells.

## Practice Section

We have supplied a practice section, so that you can gain more experience with these methods.

## Related Articles

<< Go Back to Number Format | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF