TXT file to Excel
 

I have a .txt file that I imported into excel. I have to manuall
change each field from general to text. Is there anyway to do thi
automatically?

Re

--
Reggie200
-----------------------------------------------------------------------
Reggie2004's Profile: http://www.excelforum.com/member.php...fo&userid=1508
View this thread: http://www.excelforum.com/showthread.php?threadid=26720

TXT file to Excel
 

Sure, with a macro. Record a macro as you import the file manually as a
start.

--
Jim Rech
Excel MVP
"Reggie2004" wrote in message
...
|
| I have a .txt file that I imported into excel. I have to manually
| change each field from general to text. Is there anyway to do this
| automatically?
|
| Reg
|
|
| --
| Reggie2004
| ------------------------------------------------------------------------
| Reggie2004's Profile:
http://www.excelforum.com/member.php...o&userid=15085
| View this thread: http://www.excelforum.com/showthread...hreadid=267208
|