Convert Text Column to Date?
 

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?

Convert Text Column to Date?
 

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?

Convert Text Column to Date?
 

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