format as "dd mmm yy"

=DATE("20"&RIGHT(A1,2),MID(A1,7,2),MID(A1,FIND("/",A1)+1,2))

this formula will give you "01 feb 09"

pls click YES if this helped


On 27 Maj, 14:23, 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