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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I convert a text cell into date cell in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/137268-how-can-i-convert-text-cell-into-date-cell-excel.html)

drocha

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

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

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

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

"drocha" wrote:

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.

David Biddulph[_2_]

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

Why not =A1 ?
--
David Biddulph

"Teethless mama" wrote in message
...
=--TEXT(A1,"D/M/YY")

"drocha" wrote:

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.

All times are GMT +1. The time now is 06:57 PM.