convert number to month literal in excel

[Guest]

I am trying to convert numbers in an excel spreadsheet to their corresponding
month name (eg. 6 to June). Is there a simple quick way to do this ?

 

[Arvi Laanemets]

Hi

=CHOOSE(A1,"January","February","March","April","May","June","July","August"
,"September","October","November","December")
or
TEXT(DATE(2000,A1,1),"mmmm")

 

[Don Guillett]

try this where c13 has the month number, ie:6
=TEXT(DATE(YEAR(TODAY()),C13,1),"mmmm")
or
=TEXT(DATE(YEAR(TODAY()),6,1),"mmmm")