Thread: Decimal Formual
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandi
 
Posts: n/a
Default Decimal Formual

I have a worksheet with numbers such as 175, 163, 250 etc. Is there a
formula without going back in and retyping all of these numbers that can turn
them into a decimal number like this: 1.75, 1.63, 2.50. I've tried to
multiply the cell by .01 but when I copy the formula down, it just copies
just the result of that cell -

Any help would be appreciated!!!! Thanks!
--
Sandi Gardner