Question

How to truncate number of characters in excel cell?

Answer 1

Answer:

Excel TRUNC Function

1. Summary. The Excel TRUNC function returns a truncated number based on an (optional) number of digits. ...
2. Truncate a number to a given precision.
3. A truncated number.
4. =TRUNC (number, [num_digits])
5. number - The number to truncate. ...
6. Use the TRUNC function to remove the fractional part of a number and return just the integer.