Thread: Converting a month number to a month name

Cell A1 has the month number e.g. 3
I want to convert this to a month name e.g. March

Could anyone please tell me if there is an easier way of doing this? I am currently doing it this way:

=TEXT(DATEVALUE("1/"&A1&"/2000"),"mmmm")

Thanks
---

AFAIK, that is probably one of the easiest ways...

Other ways, are the CHOOSE() Function..

e.g. =CHOOSE(A1,"January","February","March", etc...)

or you can have a list of numbers, 1 to 12 somewhere, with corresponding months next to them... then use a LOOKUP function

e.g. =Lookup(A1,X1:Y12) where X1:Y12 contain the lookup table...

yours could be shortened a little to:

=TEXT("1/"&A1&"/2000"+0,"mmmm")