You may need to translate the year to the desired century. When I tried, 09
was treated as 1909.
--
David Biddulph

"Homey" <none wrote in message
...
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.