Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Have a number of text files which have numbers next to names, tab delimited:

000454          Name1
005005          Name2
000643          Name3
4043            Name4
33643           Name5

I frequently need to import it into excel to do things. But when I import it in excel it removes all those leading zeroes. I can't do a concatenate to add two zeroes to the beginning because some never have zeroes infront to begin with, and then becomes a painful manual process of rechecking and adding.

So my question is how can I import it into excel without this happening ?

Cheers

share|improve this question

1 Answer 1

up vote 5 down vote accepted

The Text Import wizard allows you to do this.

In MS Excel 2010 & 2007:

  1. Click the "Data" Tab
  2. Click "From Text"
  3. Select Delimited,
  4. Select Tab as the delimiter,
  5. Select the column with your 'numbers' and set the Column Data Format as Text.
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.