Excel Automatically dividing the cell by 100

[steveferris]

Everytime I put a figure into excel it is dividing the value by 100. i.e if I put in 200 it returns 2, if I put in 375 it returns 3.75

I am using Office 2003 and I have tried unistalling and reinstalling but no joy. It is happening against every cell so must be a global change setting, but I can't seem to loacte the setting. Any help would be much appreciated.

Thanks in advance

Steve

 

[Richard Schollar]

Hi Steve

Check Tools>Options>Edit tab and uncheck "Fixed Decimal Places"

 

[steveferris]

Richard, you are a diamond. Thanks for the reply. Duly sorted and back to normal.