Forum Discussion
How do you stop Excel from removing leading zeros?
The part that catches most people here is the timing. Once a CSV has been opened by double-clicking it, Excel has already decided 00125 is the number 125, and the zeros are gone from the file as Excel sees it. Formatting those cells as Text afterwards won't bring them back, because there's nothing left to format — you'd have to close without saving and import it again properly.
For sharing, that's why the file format matters more than any setting on your own PC. A CSV stores no formatting at all, so each colleague who double-clicks it gets the same conversion. If you send the same data as a workbook instead, with the product-code column already set to Text before you save it, the codes arrive intact. Per Microsoft Support's automatic data conversions documentation, the newer Excel option to stop removing leading zeros is a setting on each person's own copy of Excel, so it only helps colleagues who have turned it on themselves. For everyone else, importing through Data, Get Data, From Text/CSV and setting that column to Text, or just sending a workbook, is the reliable route.