| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel file opens MS Excel Training Webpage When the Excel file ope | Excel Discussion (Misc queries) | |||
| How to copy 2007 excel file formula results into a 2003 Excel file | Excel Discussion (Misc queries) | |||
| double click excel file on the desktop excel opens but not file? | Excel Discussion (Misc queries) | |||
| Excel 2003: doubleclick on file opens Excel window, not file. | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
Hybrid Mode
