Maintaining Leading Zeros when saved as a .CSV File

[amichalosky]

I have a column, formatted as "text" with a 7-character alphanumeric code. Some codes have a leading zero. When I save the Excel file as a .csv, then reopen it, the leading zero disappears. I need that zero as this is my unique identifier field. I've tried the ' in front, I've tried formatting as text, as general...ANY ADVICE?????

 

[Domenic]

First, change the file extension from .csv to .txt. Then open the .txt file from Excel. The Text Import Wizard should pop-up. When you get to Step 3, select your column and choose 'Text' for your Data Format.