|
|
How to convert Month Number to Month Name in Excel
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.
|