| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing text file
Ive trying to import a fixed length text file (2408 rows) in to excel. In
two of the columns have mostly digits, but about 20% are text. The import wizard will not allow me to change the two fields to text. Its grayed out. Is there away around this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
if I am just trying to get round the problem I edit the text file putting in a new first row of text. Import the file and delete the first row. Do you need to do it regularly? regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=564210 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
Yes
"tony h" wrote: if I am just trying to get round the problem I edit the text file putting in a new first row of text. Import the file and delete the first row. Do you need to do it regularly? regards -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=564210 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
I've never seen the File|open Text import wizard behave that way.
Can you describe what you're doing in more detail? schildb wrote: Ive trying to import a fixed length text file (2408 rows) in to excel. In two of the columns have mostly digits, but about 20% are text. The import wizard will not allow me to change the two fields to text. Its grayed out. Is there away around this? -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
Reinstalling Office appears to have fixed the problem.
"Dave Peterson" wrote: I've never seen the File|open Text import wizard behave that way. Can you describe what you're doing in more detail? schildb wrote: I€„¢ve trying to import a fixed length text file (2408 rows) in to excel. In two of the columns have mostly digits, but about 20% are text. The import wizard will not allow me to change the two fields to text. It€„¢s grayed out. Is there away around this? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
Glad you got it fixed--but it still sounds very strange to me.
schildb wrote: Reinstalling Office appears to have fixed the problem. "Dave Peterson" wrote: I've never seen the File|open Text import wizard behave that way. Can you describe what you're doing in more detail? schildb wrote: I€„¢ve trying to import a fixed length text file (2408 rows) in to excel. In two of the columns have mostly digits, but about 20% are text. The import wizard will not allow me to change the two fields to text. It€„¢s grayed out. Is there away around this? -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
Dave, I agree with you. -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=564210 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
Dave, I agree with you. Quite bizarre -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=564210 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Importing text file
Dave, I agree with you. Quite bizarre -- tony h ------------------------------------------------------------------------ tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074 View this thread: http://www.excelforum.com/showthread...hreadid=564210 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Need Help Importing Text File Using Two or More Spaces as the Delimiter | Excel Discussion (Misc queries) | |||
| Exporting and Importing Named cells to and from a text file | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
