Retaining format while file conversion

  • Thread starter Thread starter Jayshree
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which is the best MBOX Converter Tool different formats conversion? 4
Set default cell format while retaining overrides 3
How to retain decimal zeroes? 5
How can I retain leading zeroes when saving as a CSV file? 1
Excel Formatting not saving 1
How can we convert OST to PDF file format? 1
Retaining formats 11
retain leading zeros when importing 1

Back
Top