I have format my cell to 3 digits with 2 decimal places. If I entered 9.999, it automatically rounds off to 10.00 on display. I cannot convert it to text for I need to put data validation on it ( valid range from 0 to 999.99 ) How will I turn off the rounding off the cell?
1 Answer
The TRUNC()
function truncates numbers - i.e. cuts them off without rounding. Therefore:
=TRUNC(9.999,2)
= 9.99