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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks