Getting the month out

[andy wilson]

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

Hi

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

Andy.

"andy wilson" <[email protected]> wrote in message
news:[email protected]...
> 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

[Stephen]

"andy wilson" <[email protected]> wrote in message
news:[email protected]...
> 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

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

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

[Roger Govier]

Hi Andy

One way
=A1 Format>Cells.Number>Custom> 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?