Translations:Basic Excel/107/en
An example of this is the use of identifier codes that consist entirely of numbers and contain leading zeros. Such a numerical code is not intended for use in calculations. However, Excel will not know (without being told) that these numbers are special, and will treat them as numbers, and will remove the leading zeros. This can cause much confusion, as the (Excel-modified) identifier will not match the original data.