View Single Post
  #1   Report Post  
Robin
 
Posts: n/a
Default format existing numbers in excel?

I have an existing spreadsheet, and I need to format existing numbers in the
cell, like 515 to 5.15 or 72957 to 729.57 without having to retype. When I
right click on the cell to format and choose number and 2 decimal places, it
adds zeros (515.00 or 72957.00) Is there ANY way to do this??