Stop Excel from converting text labels in CSV files to Values
 

I have a rather frustrating problem. We have a macro that extracts plant
codes from a list and creates a csv file of these codes. Many of these codes
have leading zeros, (ie. 0075, 0100, etc.) When this csv file is opened in
Excel, it converts the labels to values (ie. 75, 100, etc.). I have opened
the csv file in a text editor, and it shows the correct label - with leading
zeros. Is there a way to get Excel to open this file without converting the
text field to values?

Rename the file to extension *.txt, then the text import wizard will popup
when you open it, click next twice and select the column in question, then
under column data format select text

Regards,

Peo Sjoblom

"Just Want a Label!" wrote:

I have a rather frustrating problem. We have a macro that extracts plant
codes from a list and creates a csv file of these codes. Many of these codes
have leading zeros, (ie. 0075, 0100, etc.) When this csv file is opened in
Excel, it converts the labels to values (ie. 75, 100, etc.). I have opened
the csv file in a text editor, and it shows the correct label - with leading
zeros. Is there a way to get Excel to open this file without converting the
text field to values?