View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
skacleve
 
Posts: n/a
Default Reformatting numbers

I received a worksheet with numbers derived from formulas in the cells. I
converted the formulas to values so I was left with only the results of the
formula. However, the numbers have about eight digits after the decimal
point. How do you eliminate all decimal places after the first two? I'm
using an old 1997 Excel version.