Hello,

i have extracted text within texts in a column of data thru left & right
function.

then i have the texts result like this

26.04.09
11.06.09
23.06.09
05.07.09
12.07.09
30.09.09

I need to change it to real dates considering that the first 2 digits are
Days and the last 2 digits are Years.
e.g.
26.04.09 ---- 26-Apr-09 or 26/04/09

thanks for helping. Any suggestion is appreciated.

--
regards