Automatic divided by 100000

Gian · May 17, 2005

Hi all,

On a new worksheet, when I type in a number in the cell, right after I hit
"Enter", it automatic divide the number by 100,000, why this happened?
Please help.

Thanks.

Gian

Peo Sjoblom · May 17, 2005

Tools>options>edit and uncheck fixed decimal places

Regards,

Peo Sjoblom

Gian · May 18, 2005

Thanks.

Peo Sjoblom said:
Tools>options>edit and uncheck fixed decimal places

Regards,

Peo Sjoblom