Change the file name of the csv file from xyz.csv to xyz.txt. When you
open this in Excel it should fire off the text import wizard, in one of
the 3 stages you can define the column types, for your column with text
that has leading zero, define the column type as text and this should
solve your problem.
--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile:
http://www.excelforum.com/member.php...o&userid=17084
View this thread:
http://www.excelforum.com/showthread...hreadid=375929