Thread: How can I convert a text cell into date cell in Excel
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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.
Reply With QuoteReply With Quote