# Get the Integer Part of a Number in Excel

Author: | Edits: don

How to get the integer part, the whole number, from a number that has a decimal after it.

This does not round the number, this ONLY returns the integer, the non-decimal part of the number.

We use the TRUNC function for this.

``````=TRUNC(number)
``````

The number argument is usually a cell reference but it can also be a hard-coded number or another function/formula. This returns: Even if I change the number to where it would normally round up, you can see that using the TRUNC function causes NO rounding to happen. ## Notes

The TRUNC function is different from the INT and the ROUND functions in that there is NO ROUNDING with the TRUNC function.

Download the attached workbook to work with the above example in Excel.

Excel Function: TRUNC()

#### Question? Ask it in our Excel Forum ##### Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

Similar Content on TeachExcel
Get the Decimal Part of a Number in Excel
Tutorial: How to get the decimal part of a number without any rounding in Excel. This tip allows yo...
Get the First Word from a Cell in Excel
Tutorial: How to use a formula to get the first word from a cell in Excel. This works for a single c...
Remove Gridlines from Only Part of a Worksheet in Excel
Tutorial: How to remove gridlines from a part of a worksheet in Excel instead of the entire workshe...
Generate a Non-Repeating List of Random Numbers in Excel - UDF
Macro: Generate a series of non-repeating random numbers in Excel with this UDF (user defined fun...
Reverse the Contents of a Cell in Excel - UDF
Macro: Reverse cell contents with this free Excel UDF (user defined function). This will mir...
Get the Numeric Value of any Constant in VBA
Tutorial: Two simple tricks to get the number value for constants in VBA and Macros for Excel. Cons...
Tutorial Details
Excel Function: TRUNC() 