I tried Text to Columns and entered Date as MDY and got 18-Feb-04.

Excel 2003

"jenn" wrote:

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.