Get the Integer Part of a Number in Excel

Add to Favorites

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

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 you...
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...
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...
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...