Actually, you *must* choose
MDY
Since that is the format of the present data, otherwise you'll return an
incorrect date, or no date at all.

After the TTC conversion, you can then custom format to whatever date
display you wish.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roger Govier" wrote in message
...
Hi

One way
Mark your range of data. DataText to ColumnsNextNextClick Radio button
for choose one of the date formats to suit.

--
Regards

Roger Govier


"Jocko69" wrote in message
...

How can I convert the following date format into something useable that
excel can recognize as a vaild date?

Here is the date format I have to work with:

Jan-01-05
Jan-02-05

, etc....


Any help would be much appreciated. Thank you!


--
Jocko69