Getting the month out

andy wilson · Dec 13, 2005

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?

Guest · Dec 13, 2005

Hi

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

Andy.

Stephen · Dec 13, 2005

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

=TEXT(A1,"mmm")
will give you Dec

Or
=TEXT(A1,"mmmm")
will give December

Roger Govier · Dec 13, 2005

Hi Andy

One way
=A1 Format>Cells.Number>Custom> mmm

Regards

Roger Govier