The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.

Name: The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.
Brand: Quizplus
Rating: 4.8 (37 reviews)

Question

The TRUNC function can be used to add insignificant zeros to the right of a decimal point for numeric data.​

Quizplus · Accepted Answer

The TRUNC function is used to truncate or remove digits after the decimal point, it does not add insignificant zeros. To add insignificant zeros, one can use the CONCAT function or simply format the cell with the desired number of decimal places.

The TRUNC Function Can Be Used to Add Insignificant Zeros