sangma07
03-27-2011, 11:26 AM
you use Excel to track identification numbers (serial numbers, tracking numbers,Office 2007 Enterprise Product Key (http://www.office2007-key.eu/), and so forth.) you could possibly uncover that if the IDs have extra than 15 digits, Excel loses the digits right after the 15th and makes them all zero. In other words,Windows 7 Pro X64 (http://www.windows-7-key.us/), type "123456789123456789" into a cell and Excel will show you "123456789123456000". 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. in this case, we don't care about performing math on things like monitoring numbers. The solution? Don't make it a number at all. Select the cells where you will be entering these identification numbers,Windows 7 Enterprise Serial (http://www.windows-7-key.us/), right-click, select Format Cells and choose the Text option in the Number tab. This tells Excel to treat the number like normal alphanumeric text, which means they will display exactly as you enetered them, but you can't really use the value represented in the string as inputs to formulas (I'm over simplifying here a bit - those formula savvy among us know there are ways around this,Office 2010 Home And Business X64 (http://www.office2010-key.ca/), but that's beyond the point of this discussion). a shortcut too,Office 2007 Enterprise Key (http://www.office2007-key.eu/), if you type an apostrophe before entering that long tracking number, that's a signal to Excel to treat the value as Text.