Hi

Try this in A6:
=TEXT(A1,"mmm")

Andy.

"andy wilson" wrote in message
...
Hi,

In A1 i've got 31-dec-2005 as a date

I need to get the month as text into A6 ie dec

Any ideas?
--
Cheers

Andy