Thanks all! 2/3 answers worked!

"Jessica" wrote:

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?