Moving The Decimal Point Of Existing Entries

  • Thread starter Thread starter The Demon
  • Start date Start date
T

The Demon

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
 
Enter 100 in a blank cell somewhere. Select that cell and click on
<copy>. Then move your cursor and highlight the cells that you want to
change. Click on Edit | Paste Special | Values (check) | Divide
(check) | OK then <Esc>. All the values will have been divided by 100
in the one operation. You can delete the 100 from the original cell.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Addition errors with Decimal Places 5
Data Validation - Complex Q 2
Decimal point in general format 1
Fill/Extend Series adding decimal points to some numbers 1
Conversions of Decimal Feet to Decimal Inches - Formula?? 0
Net should be zero but it is not; decimal values aroung the 12 dec 10
adding digits with moving decimals 3
Adding numerals with moving decimals 2

Back
Top