View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
The Demon The Demon is offline
external usenet poster
 
Posts: 1
Default Moving The Decimal Point Of Existing Entries

Hi Everyone, hoping someone can help me with this.

I have a massive sheet full of numbers, however, they should have been
entered as values less than 1.

eg - Cell has an entry of "5" and it should be "0.05"

Is there anyway I can move the decimal place in the cells I want to?

Thanks for your help,

The Demon, Sunny Scotland