Hi Andy

One way
=A1 FormatCells.NumberCustom mmm

Regards

Roger Govier


andy wilson wrote:
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?