Excel treats a product number as a number, and that changes it in three ways. BarcodePop notices all three before it draws anything.
The leading zero is gone #
Type 012345678905 and Excel keeps 12345678905. BarcodePop sees numbers that are one digit short of UPC-A, EAN-13, ITF-14 or UPC-E and adds the zero back: the card shows Add the missing leading zero with a line such as 20 numbers are one digit short, as if Excel dropped a leading zero., and the type reason says 11 digits, the leading zero Excel dropped is added. The switch is on by default; turn it off if your numbers really are shorter and have no check digit yet. Settings has the same switch as the default.
A number formatted with zeros (for example the custom number format 0000000000000) keeps the zeros you see, and BarcodePop uses what the cell shows.
The number was rounded #
Excel keeps only 15 significant digits. A 16-digit or longer number typed as a number ends in zeros that you did not type, and no barcode can bring the lost digits back. BarcodePop skips those rows: Row 4: Excel has rounded this number. Format the column as Text and type it again.
The cell shows 1.23E+12 #
Scientific notation is only how the number is shown. BarcodePop reads the exact number behind it (as long as it has 15 digits or fewer), so the barcode is right. To see the full number in the sheet, give the column the Number format with 0 decimals, or format it as Text.
Keep numbers intact from the start #
- Select the column, then Home > Number Format > Text, before you type or paste the numbers.
- Or type an apostrophe in front of the number:
'012345678905. - When importing a CSV file, set the column type to Text in the import (Data > From Text/CSV > Transform Data).
Numbers that were already rounded have to be typed or imported again; BarcodePop lists their rows so you know which ones.
