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?