View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BSantos BSantos is offline
external usenet poster
 
Posts: 1
Default rounding and comparing cells

Does anyone know how to format this.

If I have in one cell $21.40 and I have another cell I'm comparing that cell
to to give me a result that has $21.3980506 in the cell. My question will not
say they match because of the string of #'s after the .39. I need to change
all the cells in that column to be only 4 digits and rounding up if necessary.

Does anyone know an easy way to do this?

Thanks, B.