Could be..........if you're using other than a U.S. version of
Excel...........give it a try.

Vaya con Dios,
Chuck, CABGx3



"Miguel" wrote:

Hi Chuck,

Thanks for your help but give me an error. Should replace "," by ";" ?
Thanks

Miguel

"CLR" wrote:

=LOOKUP((MID(A1,FIND("-",A1,1)+1,2)*1),{1,2,3,4,5,6,7,8,9,10,11,12},{"Jan uary","February","March","April","May","June","Jul y","August","September","October","November","Dece mber"})

All on one line, watch out for word-wrap.

Vaya con Dios,
Chuck, CABGx3



"Miguel" wrote:

How I can convert 21-05-2007 to text May ?