The TRUNC function truncate decimals, that means remove fractional part of a number.

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

## Syntax

TRUNC(number, [num_digits])

*number**Number you want to truncate.***[num_digits]**A number to specify precision to truncate a number.

## Example

In the below example, we have used this function to truncate data for removing time from the dates.

As you know, dates are serial numbers and time is in decimal in Excel.

## Sample File

Download this sample file from here to learn more.

## Remember

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

## Leave A Comment