Last updated 22/01/2021
Microsoft Excel often abbreviates long numbers using "Floating-point arithmetic". It will turn a long number such as a barcode into a shorter number, like this '9.7686E+21'. While useful for mathematicians, it's less so for presenting long strings of numbers such as barcodes or phone numbers.
Luckily this is easy to resolve.
When Microsoft Excel considers a column to be formatted as a number, it will remove any leading 0s. For example, "09" becomes "9".
This is sometimes unhelpful if you wish to store telephone numbers or barcodes in your document.
This can be solved by formatting the column as Text.
If using a .csv file, if you open the file directly from Excel, you may find that the leading zeros have been stripped from your numbers before you’ve had a chance to format the columns.
This can be solved by importing the data into Excel instead of opening it directly.
While sometimes unavoidable, it is recommended to not use codes or barcodes that begin with "0"s. It will save you the hassle of having to update the column format whenever you use Microsoft Excel.
We really appreciate your feedback.