How to use TRUNC Function in Excel

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.


TRUNC(number, [num_digits])

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


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.

examples to understand excel trunc function


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