=TEXT(A1,"0000\-00\-00")+0

Format as date.

HTH
Jason
Atlanta, GA

-----Original 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?
.