View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default

The formula to round in this manner is
=ROUND(#, -2)

The # can be a cell reference or a hard-coded number.

Do you need to apply it to an entire sprdsht?