Thanks Shaun,Punter Pete,Puntz.

Finally got back to it(10.30 am)and found it. Wasn't in 1 worksheet but in all my 293 Workbooks years old so knew it wasn't in Format/Cells. So had to be in Tools. It was,Tools/Options/Edit--Fixed Decimial. Removed the Tick. Now I can put a number in a cell and it dosen't change.

Thanks again Ray.