Number entered isn't number recorded in cell.
Thanks for the help.
--
BubbaGee
"bj" wrote:
check tools-options-edit
unselect fixed decimal places (Halfway down on left)
"BubbaGee" wrote:
If you enter a "1" in the cell and hit Enter you get "0.00001" in the cell.
If you enter "1." you get "1" in the cell. Looked everywhere I could for
some type of formating that was causing it and can't find anything. It
happens with any spreadsheet that is run on one system we have. It doesn't
matter where or when the spreadsheet was first created and you can put the
spreadsheet on any other system and it is fine. Seems to be only one system
that is affected.
Any ideas what is going on?
Thanks,
|