Date format issue

[kesavanprabhu]

Hello

I am downloading a report from an ERP the date column in the report will be as shown below but the actual date is 13-12-02
13-12-07,14-01-10,14-01-11,14-01-12(yymmdd)

now pls advise how i can delete this 20 in the sequence.

example
13-12-2002
13-12-2007
14-01-2010
14-01-2011
14-01-2012

Thanks in advance

[oeldere]

format the cells as:

dd-mm-yy

[kesavanprabhu]

format the cells as:

dd-mm-yy

I tried per your advice 20 is removed but if i sort the data it is not sorting properly.

the sorting should also be done.

Please advise.

[oeldere]

I didn't see an question about sorting in your question.

What did you expect to be the result?

If I sort the data it's sorting well.