entering number changes to 100th of value 1

[gremlins]

Whenever I enter a number into excel, it is converting it to 1 hundredth of the value.

So I enter 2 and it puts 0.002 in the cell. It's been doing this for a while now and I can't seem to get rid of it.

I have looked at what the cells are formatted as but it's just general. It does this at start up.

Any help much appreciated

 

[SkipVought]

HI,

Tools/Options - Edit Tab - UNCHECK fixed decimal

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at faq222-2244

 

[gremlins]

cheers