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.

Syntax

TRUNC(number, [num_digits])

number Number you want to truncate

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

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

Examples

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.

Sample File

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.