Hi Eduardo,

No, it doesn't work. It showed "#VALUE!".

"Eduardo" wrote:

Hi,
I assumed your information is in column A, in column B enter

=DATE(VALUE(LEFT(A1,1)),VALUE(MID(A1,2,2)),VALUE(R IGHT(A1,2)))

"lalann" wrote:

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