If you use Excel to track identification numbers (serial numbers, tracking numbers, etc.) you may find that if the IDs have more than 15 digits, Excel loses the digits after the 15th and makes them all zero. In other words, type "123456789123456789" into a cell and Excel will show you "123456789123456 000 ". What's going on? Is this a bug?! Nope. You've hit an Excel limit with how large of a number Excel can handle when performing math operations on a number. But in this
Read More...
Read the complete post at http://blogs.msdn.com/excel/archive/2009/01/19/when-a-number-is-not-a-number.aspx
Posted
Jan 19 2009, 07:43 PM
by
Microsoft Excel