Number entered isn't number recorded in cell.
<Tools <Options <Edit tab,
And *UNCHECK*
"Fixed Decimals".
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"BubbaGee" wrote in message
...
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,
|