Automatic divided by 100000

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

Tools>options>edit and uncheck fixed decimal places

Regards,

Peo Sjoblom

"Gian" wrote:

> 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

Thanks.

"Peo Sjoblom" wrote:

> Tools>options>edit and uncheck fixed decimal places
>
> Regards,
>
> Peo Sjoblom
>
> "Gian" wrote:
>
> > 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