Shifting decimal places

[krishnanaik]

Hi!!
I have a list of over 8000 numbers with no decimal points inserted. How do a chnage a number from say £8765 to £87.65 or £1234 to £12.34

Please let me know

Much appreciated.
Krishna

 

[onlyadrafter]

Hello,

Enter 100 in a cell, select this cell, then select EDIT --> COPY, then select the cells with 8765, 1234 etc. then select EDIT --> PASTE SPECIAL, and check the DIVIDE check box.

 

[Andrew Poulsom]

Type 100 in a spare cell and copy it to the clipboard. Select your list of numbers, right click, choose Paste Special, check divide and click OK.

 

[krishnanaik]

Thanks Guys