Assuming the century will always be 20

=DATE(VALUE("20" & RIGHT(A1,2)),MID(A1,7,2),MID(A1,5,2))

If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

In cell A1, data is of 10 digit whose last 6 digit is in form of ddmmyy.
how can i get date, month and year in cell A2 from this.

e.g. A1 A2
UPR/010209 01 FEB 09