Change to appropriate cell reference:
=DATEVALUE(SUBSTITUTE(A1,"/",", "))

--
Best Regards,

Luke M
"PAL" wrote in message
...
I have been given a database dump (thousands of rows) that put the dates in
a
text format like this:

Aug/11/2009

Is there any way to put this into a date format? Even if it means creating
a
new field breaking it up and doing some extra steps.

Thanks.