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 ?