Select dates and do Data / Text To Columns, then in the wizard choose the
appropriate date option for your column

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Jessica" wrote in message
...
I have exported this field using RIGHT, MID, LEFT, & functions but I am
left
with a column that looks like 2005/01/18. I then paste values and when I
format as a date it does nothing until I press F2 for each cell. I have
many
rows, is there an easier way to make the date field usable?