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 IDsFastest fix
Upload the file and see exactly which rows cause the problem. Free, and the file stays in your browser.
Why this happens
- Excel treats the column as a number, and numbers don't have leading zeros.
How to fix it
- 1Format the column as Text before typing or importing.
- 2When importing a CSV, choose Text for those columns in the import wizard.
- 3If zeros are already gone, restore them from the original export, not by guessing.
Related guides
Excel
“Excel cannot open the file because the file format or file extension is not valid”
ExcelExcel error “SYLK: File format is not valid” when opening a CSV
Excel“We found a problem with some content” — Excel workbook won't open properly
Still stuck? Ask SheetFix Support