Hi TOm

That's not 100th, it's 20th. With your number in A1, formula in B1:
=ROUND(A1/5,2)*5

HTH. Best wishes Harald

"Tom C" skrev i melding
...
If i have a number such as 19.57, how can i get Excel (Office XP) to round
it off to the nearest 100th. To where it would be 19.55 or if the number
was
19.58, i would want it to round up to 19.60.
Thanks for the help...Tom