My Crappy Mind

August 29, 2008

The Mystery of 16th Digit of Microsoft Excel 2007

Filed under: Annoyance — MindCrap @ 6:36 pm
Tags: ,

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.

2 Comments »

  1. 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 | Reply

  2. 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 | Reply


RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.