View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

=ROUND(C10*20,0)/20

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lk" wrote in message
...
I am using Excel 2003

How do you round the contents of a cell to the closest five cents.

Thanks
lk