Retaining format while file conversion

J

Jayshree

Hi!

I have few text files with more than 6000 records. There are columns
in which the data stats with 0 digit for ex. 021996000058.

While I convert this .txt file into .xls file the leading zero
disappers. for ex. the above given number becomes 21996000058.

Is there any way by which I can retain the data with same format as in
the text file?

Please help!

Jayshree
 
G

Guest

Hi

When you open the txt file in Excel it should launch the Text Import Wizard
which lets you assign which fields are text fields as well as
delimiter/fixed width etc.
 
Top