Put 100 in an unused cell
Edit|copy that cell

Select the range to adjust
Edit|paste special|click Divide and Values

Clean up that cell that you put the 100 in.

Steved wrote:

Hello from Steved

Please my objective is as set out below

547 to become 5.47
600 to become 6.00
912 to become 9.12 and so on how do I acheive this

I Thankyou.

--

Dave Peterson