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