Yesup
 
 

Yamabay Knowledge Base

 

How to convert Month Number to Month Name in Excel

Previous Article Back to TOC Next Article

There are at least two easy ways to convert Month Number (1,2,3...12) to Month Name (January, February.... December). The first one is to Format Cell as Custom, and the Format is mmmm for Full Names, and mmm for Abbreviated Names (Jan, Feb. Mar. etc.). The 2nd way is to use Formula like below:


=CHOOSE(MONTH(NOW()),"January","February",
"March","April","May","June","July",
"August","September","October","November",
"December")


Please note that the first parameter is supposed to be an integer between 1 and 12 inclusive to make sense.

Yesup
Top Stories Travel Movies Gift Ideas Free Software Games