preventing division by 10000 when entering cell value in xcel

[Bill T]

Every time I enter an interger in a cell it divides by 10,000 and replaces my
origingal enterger with a new number eg. 20 becomes .002 in the excel
program. I have tried to format cells as numbers, General, etc. with no
decimal places all to no avail. Can someone help???

Bill T

 

[Peo Sjoblom]

Tools>options>edit, uncheck fixed decimal places
It is a handy option if you type in things like in accounting and want to
be able to type 14355 to get $ 143.55 but it is important to remember to
turn it off



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)

 

[rmg]

Tools>options>edit, uncheck fixed decimal places
It is a handy option if you type in things like in accounting and want to
be able to type 14355 to get $ 143.55 but it is important to remember to
turn it off



--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)