how to use excel trunc function

Quick Intro

Truncate Decimals with Trunc Function. TRUNC Function can be helpful to remove fractional part of a number.

In simple words, it will remove decimals from a number to a specific precision and then return integer part in the result.

In the below example, I have used this excel function to truncate decimals and it has returned the integer part of the number without decimals as I have specified precision to zero.

Definition of Excel Trunc Function


TRUNC(number, [num_digits])

number Number you want to truncate

[num_digits] A number to specify precision to truncate a number.

More Information for Excel TRUNC Function

  • TRUNC is similar to INT in work.
  • The difference is that trunc only remove decimals from a number where INT remove decimals by rounding down the number to the nearest integer.


In the below example, we have used this function to truncate data for removing time from the dates. As you know, excel dates are numbers in actual and time is in decimals.

Examples To Understand Excel Trunc Function

Sample File

download sample file to learn more about this tips

What’s Next?

To learn more about Excel TRUNC Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There is also you have INT function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.