You can use the following formula in Excel to convert a number between 1 and 12 to a month name:
This particular formula converts the number in cell A2 to a month name.
For example, if cell A2 contains the number 8 then then this formula will return August, since the eighth month of the year is August.
The following examples show how to use each formula in practice.
Example: Convert Numbers 1-12 to Month Name in Excel
Suppose we have the following column of month numbers in Excel:
We can type the following formula into cell B2 to convert the number in cell A2 to a month name:
We can then drag and fill this formula down to each remaining cell in column B:
Column B now displays the month name for each month number in column A.
If you would instead like to display the abbreviated month name then you can use “mmm” in the TEXT function instead:
The following screenshot shows how to use this formula in practice:
Column B now displays the abbreviated month name for each month number in column A.
How This Formula Works
Recall the formula that we used to convert the number in cell A2 to a month name:
First, we multiply the value in cell A2 by 28.
For example, we in cell A2 we get 1 * 28 = 28.
By default, Excel uses serial numbers to represent dates as the number of days since 1/1/1900.
Thus, 28 is interpreted as 1/29/1900.
Then we use the TEXT function to format this date as a full month name by specifying “mmmm” as the format code.
The same step is repeated for each numeric value in column A to return the correct month name.
Note that you could also multiply by 29 and the formula would return the correct month name.
However, any number besides 28 and 29 will not return the correct month names for each month.
The following tutorials explain how to perform other common tasks in Excel: