Excel 2003 can not show 1000000000000001 (16 digits) correctly.

[Whta is the problem?]

Excel 2003 can not show 1000000000000001 (16 digits) correctly.

1000000000000000 shows 1000000000000000
1000000000000001 shows 1000000000000000
1000000000000002 shows 1000000000000000
1000000000000003 shows 1000000000000000
1000000000000004 shows 1000000000000000
1000000000000005 shows 1000000000000000
1000000000000006 shows 1000000000000010
1000000000000007 shows 1000000000000010
1000000000000008 shows 1000000000000010
1000000000000009 shows 1000000000000010
1000000000000010 shows 1000000000000010

 

[Bernard Liengme]

Excel, like many computer apps, uses the IEEE method for storing numbers so
is limited to 15/16 decimal digits of precision. If you want more then
precede it with single quote (apostrophe) to make it text - you will not be
able to do math on the "number".
If you want to do high-precision math try MuPad Lite (free - do a Google to
find it)
Suggest future question like this be sent to one of the Excel newsgroups.

best wishes