you maybe want formula like
=DATE(RIGHT(RIGHT(A1,6),2),MID(RIGHT(A1,6),3,2),LE FT(RIGHT(A1,6),2))
in cell b1 and copy down next to data in col A.

"aditya" wrote in message
...
| Data in column A is of 8/9/10 or 11 digit.
| However in every case last 6 digit is in form of ddmmyy. how can i get
date
| from this in column B.