Inserting decimal point

[nickharr]

I would be grateful if someone could give me a formula to insert a decimal point into a column of numbers. Cell A1 at present shows 795 and I need it to show 7.95. Cell A2 shows 1199 and I need it to show 11.99. etc.
Many thanks for any help.

 

[RoryA]

enter 0.01 into a cell, copy it, then select the data and choose Paste Special, Values and Multiply.

 

[VoG]

Type 100 into a spare cell then copy it.

Select your column of numbers, Edit > Paste Special, tick Divide then click OK.

 

[nickharr]

Thanks a lot guys - that works a treat.