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