Hi,
Say a text-date is in A1, in B1: =Value(A1)
It returns the number; just format column B as a date
Sebastien

"simsjr" wrote:

I have a column of dates, but they're in text format. How can I convert the
text "02/05/05" into an actual date?