How can I save an Excel spreadsheet to CSV and preserve the format?
Spreadsheet with 2 columns, A and B.
Column A contains Item numbers, many of which start with leading zeros. ie 00001, 00002, etc...
When you save the Excel spreadsheet to CSV it removes the leading zeros and the numbers show up only as 1, 2 etc.. it must keep the leading zeros.