No rounding

[onelowburb]

Ok as we all know when u have a number like 56.234589 and i only really want to see 5 digits because the 6 digit is a 9 it rounds the 5th digit up or if the 6th number was less than 5 then it would round down i dont want it to do anything i want whatever the number is suppose to be i just dont want to see the rest of the digits past the 5th one... can anyone help........thx

 

[Richard Schollar]

Hi

Use the Trunc function:

=TRUNC(A1,5)

Best regards

Richard