text is being interpreted as a date

[tommy03]

I have the following value which I split into 4 columns using Text T
Columns (within a vba routine) :

02-9508~8203.20.6060~646~5.

(delimited on the ~ )


the problem is that the first column of data gets automatically (an
incorrectly) recognized as a date (Feb-08).

If I format it afterwards, it turns it into 2778797.

That value is supposed to be text (02-9508).

does anyone know how I can keep excel from incorrectly misinterprettin
the format of the data ???

:confused

 

[ElsiePOA]

format your columns as "Text" before you do your text to column

 

[ElsiePOA]

Sorry - disregard my previous response. Formatting for textworks if yo
are going to enter 02-9804 from the keyboard, but not from "text t
columns". I'll have to think about it further

 

[ElsiePOA]

Let's try this again:
In step three of "Text to Columns" there is a box named "Column Dat
Format". In this box, select "Text". That should solve your proble

 

[tommy03]

yeah Elsie...

my brain had an out of body experience and it took all common sense an
logic with it

I'm better now


(yikes!!! that was a serious DUH question )

thanks for waking me up

:

 

[ElsiePOA]

Just wait until you see how bad it gets after you've turned 70