Leave the f'ing leading zeros!!
If my data has leading zeros, then I want leading zeros!.... How is that so hard to understand!?!... Make truncating leading zeros an optional setting, not the default.
Thanks for the hint, though I use Open Office Calc to open .csv's since it gives me the option of formatting the columns how I want as it opens.
That's not really my point, though. If the data has leading zeros, wherever it's coming from, then I probably want the leading zeros and Excel should just leave them there. It would be far more convenient to make that the default and truncating the leading zeros the formatting option. I'd rather trim data than not have access to it in the first place.
Sean Kennedy commented
Is your data coming from another source? Ie: export to CSV? If you open the CSV in Excel as opposed to a text editor, it will get rid of leading zeros. If you do not open and import through Power Query, you will also be able to avoid.