Try

=--SUBSTITUTE(A2,".","-")

and format as date

--


Regards,


Peo Sjoblom

"Mati" wrote in message
...
Need help to convert format "26.01.2008" to "January,2008". I have tried
formatting under dates etc and unfortunately it does not work.
Thanks,
Mati