Posted to microsoft.public.excel.misc
|
|
preventing division by 10000 when entering cell value in xcel
"Peo Sjoblom" wrote:
Toolsoptionsedit, 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)
"Bill T" <Bill wrote in message
...
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
|