How can I convert a text cell into date cell in Excel

drocha · Mar 30, 2007

I have the following cell: =text(A1,"D/M/YY"). How can I convert that cell
to a date cell. I am using Excel 2000.

Teethless mama · Mar 30, 2007

=--TEXT(A1,"D/M/YY")

David Biddulph · Apr 2, 2007

Why not =A1 ?
--
David Biddulph

Teethless mama said:
=--TEXT(A1,"D/M/YY")