If you’re working with a list of month numbers in Excel (e.g., 1 for January, 2 for February, etc.), and you want to display the corresponding month name, there’s a simple formula you can use.
✅ Formula to Convert Month Number to Full Month Name #
Assuming the month number is in cell A2, use the following formula:
🔍 This will return:
-
Januaryfor 1 -
Februaryfor 2 -
Marchfor 3 -
…and so on.
If you prefer abbreviated month names like Jan, Feb, Mar, simply change
"mmmm"to"mmm":
✅ Apply It to a Whole Column #
If you have month numbers in column A starting from row 2, just place the formula in column B like this:
Then drag the formula down to apply it to the entire column.
📝 Final Tip #
This formula uses the year 2025 as a placeholder—any valid year works. The key is that the month number is used to generate a real date, and the TEXT function formats it to show the month name.
Using this method will help you organize reports, charts, or dashboards more clearly by displaying friendly month names instead of just numbers.
