Why are my cell being divided by 100?
 

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

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

"Bill" wrote in message
...
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

Thanks this has been driving me crazy all day.

Great reply! Thanks again.

"N Harkawat" wrote:

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

"Bill" wrote in message
...
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