View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roberta
 
Posts: n/a
Default Mistake of changing decimal into whole numbers

Earlier in the year we rec'd a spreadsheet for prices. The format was 2.30,
1.05 etc. to make it simpler, someone change it to 230, 105 and the
decimals was assumed after the 1st digit. Now the customer wants it back to
2.30 vs 230 but the format has been permanently changed. Is there any hope
here of changing it back?