Excel removes leading zeros (0612…, 01234) — how to keep them

Keep zeros in zip codes, phone numbers, article numbers and customer IDs.

The message you see
Excel removes leading zeros from postcodes and IDs
Fastest fix

Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.

Clean my CSV without losing zeros →

Why this happens

How to fix it

  1. 1Format the column as Text before typing or importing.
  2. 2When importing a CSV, choose Text for those columns in the import wizard.
  3. 3If zeros are already gone, restore them from the original export, not by guessing.

Related guides

Still stuck? Ask SheetFix Support