software

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 = quot;Januaryquot;.

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),quot;MMMMquot;)

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

--

Dave Peterson


Here's another way

=TEXT(A1*29,quot;mmmmquot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=536616Nice one.
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;daddylonglegsquot;wrote in message...

Here's another way
=TEXT(A1*29,quot;mmmmquot;)


Both are great. Thanks guys!

daddylonglegs Wrote:
gt; Here's another way
gt;
gt; =TEXT(A1*29,quot;mmmmquot;)
gt;
gt;
gt; --
gt; daddylonglegs
gt; ------------------------------------------------------------------------
gt; daddylonglegs's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30486
gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=536616--
cygnus