One way that might work, select all dates and do edit replace and replace /
with /
(yes repleace the forward slash with a forward slash)
another thing might be to copy an empty cell, select the dates and do
editpaste special and select add,
then reformat as dates again yyyy/mm/dd

--

Regards,

Peo Sjoblom


"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?