The TRUNC function is to return the exact number with the digits you specified.
Formula:
=TRUNC(number, [num_digits])
Explanations:
– The number is required, which is the number to truncate.
– Num_digits is required, which is the number of digits to keep.