Prevent reformatting of data in CSV import in Excel
Posted on 2012-09-04
How to force excel to treat columns as text automatically. I have a .csv file as below
The third column always has the leading 0 stripped. I know I can change it to a .txt file name and use the import wizard dialogue to manually treat the column as text. But I really prefer it to be automatic and not force the user to constantly manually set column types. Is there a way to force the column to automatically be text? I thought I had read something about apostrophe at the start of the column but that doesn't seem to work, the apostrophe stays in the column in Excel.