View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lalann lalann is offline
external usenet poster
 
Posts: 11
Default How to transfer "text" into "date"?

Hi,

The dates shown in the report are in text format. As you can see below, it
is "DD-MM-YYYY". But as it's is in text format, I can't use it as "date" to
do the further analysis. Is there any ways to change the below text into
"date"? Thanks.

14-12-1969
26-12-1962
01-06-1960
29-05-1963