Convert Text Column to Date?

[simsjr]

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?

[sebastienm]

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?

[Myrna Larson]

Another way is Search and Replace: Replace / with /. That forces Excel to
re-evaluate the cell contents.

On Wed, 9 Feb 2005 15:09:04 -0800, simsjr <[email protected]>
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?