Importing text file

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?

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

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
>
>

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

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
>

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

Dave, I agree with you.

Dave, I agree with you. Quite bizarre

Dave, I agree with you. Quite bizarre