G
Guest
HI,
I have read throught some of the posts on date formats but I can't seem to
find the answer. I want to convert dates in the text format Feb 18/04 to date
format 18-Feb-04. When I try text to columns it doesn't recognize the two
digit year and results in a column with the month and and one with the day
and year.
Thanks for your help.
I have read throught some of the posts on date formats but I can't seem to
find the answer. I want to convert dates in the text format Feb 18/04 to date
format 18-Feb-04. When I try text to columns it doesn't recognize the two
digit year and results in a column with the month and and one with the day
and year.
Thanks for your help.