Is it just me or something is wrong.
It seems like excel steal every smallest digit starting from the 16th.
Try putting 9999999999999999 to a number formatted cell.
Is it just me or something is wrong.
It seems like excel steal every smallest digit starting from the 16th.
Try putting 9999999999999999 to a number formatted cell.
RSS feed for comments on this post. TrackBack URI
Excel can only manage 15 digits of precision. But that’s a pretty big number.
http://www.dailydoseofexcel.com/archives/2004/05/05/credit-card-numbers/
Comment by Dick Kusleika — September 2, 2008 @ 12:41 am |
Its not enough when you tried to generate 16 digit sequential identification number.
maybe i should find another way :p
Comment by MindCrap — November 11, 2008 @ 12:31 am |