Not thru format. However using this function at each instance where you want
it rounded
=Mround(a1,0.005)


"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