Six spreadsheet errors that silently corrupt first imports
Excel often turns 13-digit EAN barcodes into scientific notation (`8.90123E+12`), ruining scanner recognition forever if saved improperly as text. Format barcode columns explicitly as Text before pasting factory digits.
Common mistakes to avoid
- —Saving Excel files after Excel silently mangled 13-digit barcodes into `E+12` scientific numbers.
- —Leaving Cost Price equal to zero across half the sheet, making initial Profit Reports falsely report 100% margins.