TXT file to Excel

[Reggie2004]

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

 

[Jim Rech]

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

--
Jim Rech
Excel MVP
|
| 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?action=getinfo&userid=15085
| View this thread: http://www.excelforum.com/showthread.php?threadid=267208
|

 

[Philo Hippo]

With ActiveSheet

With .UsedRange
.NumberFormat = "@"
End With

End With