text is being interpreted as a date

T

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
 
E

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
 
E

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
 
T

tommy03

yeah Elsie...

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

I'm better now ;)


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

thanks for waking me up ;)

:
 
Top