One way:

=ROUND(A1/0.005,0)*0.005
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"KevinBoyden" wrote in message
...
I have a sheet where i need to show all numbers ending in 0 or 5 so 98.321
would show as 98.320 and 98.324 would show as 98.325 etc... I am obviously
not gr8 at excel so would appreciate som assistance

Cheers Kevin