Get the Integer Part of a Number in Excel

Add to Favorites
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.

4641b251bc5f1346999cd474584e6e75.png

This returns:

14c8b679553dffc8680fc7c1d9cc10eb.png

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.

3cc6de21a37ee5eb4ff2f5d647e138bb.png

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()
Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
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.)

View Course

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...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...
Tutorial Details
Excel Function: TRUNC()
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
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.)

View Course