Wrong number entry over 16 digits

[Joel]

I have found a bug in Microsoft excel 2002, tried on
different computers - the same phenomenon exists.

When entering a number with over 16 digits, the 16th
digit and on all are truncated to a zero. (nullified)
It's not just a problem of displaying the data - the
number is actually stored with the wrong digits!!

Is this a known phenomenon?
in my applications - this is a very serious bug, causing
loss of income etc..

Appreciate your comments,

Joel

 

[Frank Kabel]

Hi
no chance around this as Excel only supports 15 significant digits. You
may take a look at:
http://www.big-numbers.com/

 

[Joel]

Thanks,

Frank

-----Original Message-----
Hi
no chance around this as Excel only supports 15 significant digits. You
may take a look at:
http://www.big-numbers.com/

--
Regards
Frank Kabel
Frankfurt, Germany



.