Truncate function

TRUNC shortens a calculated value to a specified number of digits. Enter a separator (shown as a comma below) after the value.

• If digit is positive, the value is truncated to that number of decimal places.
• If digit is negative, the value is truncated to the left of the decimal point.

Syntax

TRUNC (value, digit)