I am using the command:

Workbooks.Open FileToOpen, Format:=2

and not the import wizard.

Robert

-----Original Message-----
in the text import wizard, in the last dialog, designate
that column as Text

--
Regards,
Tom Ogilvy

"Robert" wrote in
message
...
I am importing a comma delimited text file into an Excel
worksheet using Excel 97. Even though a field is
represented in the text file as "000234" (i.e. a text
field), it shows in the worksheet as 234.

How can I prevent the leading zeroes from being dropped?

Thanks


.