Why are my cell being divided by 100?

[Guest]

Every number I enter gets automatically divided by 100. If I enter 100 the
cell has a 1 in it. If I enter 1 then the cell results in .01???

Somehow this happend in the last few days but I cannot fix it. Format cells
only changes the amount of digits shown. If I format it with accounting or
currency or number is has no effect.

Any Ideas????

Bill

 

[N Harkawat]

go to tools-->options-->edit
and uncheck fixed decimal place

 

[Guest]

Thanks this has been driving me crazy all day.

Great reply! Thanks again.