Thread
:
preventing division by 10000 when entering cell value in xcel
View Single Post
#
2
Posted to microsoft.public.excel.misc
Peo Sjoblom
external usenet poster
Posts: 299
preventing division by 10000 when entering cell value in xcel
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
Reply With Quote
Peo Sjoblom
View Public Profile
Find all posts by Peo Sjoblom