CSV leading zeroes

[Doyle F]

I create csv files from another application and send them
to users. If a column has leading zeroes, Excel removes
them. Is there a way to get Excel not to remove leading
zeroes in columns when opening up CSV files.
Example:
test.csv looks like this
Name,BadgeNumber
"Tom Smith","123456"
"Mary Jones","00654"

 

[J.E. McGimpsey]

I create csv files from another application and send them
to users. If a column has leading zeroes, Excel removes
them. Is there a way to get Excel not to remove leading
zeroes in columns when opening up CSV files.
Example:
test.csv looks like this
Name,BadgeNumber
"Tom Smith","123456"
"Mary Jones","00654"

Change the extension from .csv to .txt and when you open the file,
use the Text Import Wizard - in the third pane, click on the second
column and select the Text radio button.

You can record a macro of this if you wish - post back if you need
help.