how to convert single digit to month name

I can't for the life of me figure out how to convert a number in a cell
which has a value of 1 to 12 into a month name.
E.g. If A1=1 then B1 should = "January".

The date functions don't seem to help unless you have a whole date E.g.
DD/MM/YYYY.

Is there a native function I can use, or am I stuck doing a vlookup on
a list I specify elsewhere?


--
cygnus

You can convert it to a date:

=date(2006,a1,1)
and format as MMMM

or

=text(date(2006,a1,1),"MMMM")

cygnus wrote:
>
> I can't for the life of me figure out how to convert a number in a cell
> which has a value of 1 to 12 into a month name.
> E.g. If A1=1 then B1 should = "January".
>
> The date functions don't seem to help unless you have a whole date E.g.
> DD/MM/YYYY.
>
> Is there a native function I can use, or am I stuck doing a vlookup on
> a list I specify elsewhere?
>
> --
> cygnus

--

Dave Peterson

Here's another way

=TEXT(A1*29,"mmmm")

Nice one.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"daddylonglegs"wrote in message...

Here's another way
=TEXT(A1*29,"mmmm")

Both are great. Thanks guys!

daddylonglegs Wrote:
> Here's another way
>
> =TEXT(A1*29,"mmmm")
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php...o&userid=30486
> View this thread:
> http://www.excelforum.com/showthread...hreadid=536616


--
cygnus