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

how to convert single digit to month name
 

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

how to convert single digit to month name
 

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

how to convert single digit to month name
 

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")

how to convert single digit to month name
 

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