I created a .csv file for import to Excel. (Prefer spreadsheet to automatically open and recipient not have to use the Wizard.)
One of the fields in the .csv file is an Item Code Number, which is numeric and can have leading zeroes.
To avoid truncation of leading zeroes when the spreadsheet opens, in the .csv file, I tried putting a single quote infront of the value (i.e. '000485) and also tried double quote/single quote/double quote around the value (i.e. "'000485"). Same result in both cases. Leading zeroes were preserved but the single quote was visible in the Cell (i.e. '000485). I don't want the single quote to be visible in the cell. I want 000485 only to be displayed.
Only way I've been able to get around your issue (I've run into it too), is to create a Macro to import the file to an empty Excel file. The macro would run the wizard for you. You can save it in CSV format, but delete the CSV extension (or save a a txt or prn file). Then in the macro, you can designate the column as a text column. In the file you originally used to create the CSV, PRN or TXT file, custom format the column cells. (Format Cells, Select "Custom", then click on the "0" below general. In the "TYPE" field, where the single 0 now appears, key in as many zeros as you want to have in the field.). WHen the file is imported and that column designated as text column, it then will appear as 0000123 instead of 123. Or you can do the formatting as part of the Macro once it's in Excel. Hope this helps.