Lisa

Three ways

1) If all the 'numbers' are the same length (4 characters) then via
FormatCells...NumberCustom, type 0000
2) Pre-format the cells to text and it will retain the leading zeroes.
3) rename the file with no extension or a *.txt one and then when you open
it Excel will invoke the import wizard, choose delimited, comma and then in
the third stage of the wizard, mark the offending column(s) as text

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Lisa" wrote in message
...
I have programs that only import the csv format. When I create the file
with
a text field using number such as 0101, 0321 if I close and reopen the
file
it drops the zero. How do I correct this?