Odd number conversions???
I've come across an interesting issue in Excel 2000 in which if I enter the
following number (as an example), 1408685345915193, Excel will store it as
1408685345915190. Interestingly enough, should I enter a larger number, for
example replacing the 1 at the beginning of the number to a 2 (theoretically
a larger number than the one ending with a 3), then Excel accepts it no
problem. Does anyone have any thoughts as to the root cause of this
particular issue? Note that I can explain further if unclear.
Thanks in advance for any feedback on this!
--
Christian
|