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