Convert Numbers into Month Names in Excel

To convert cells with month numbers such as 1, 2, 3, 4, etc, use the following formulas: =TEXT(DATE(2000,A1,1),"mmmm") for Full Month Name (January, February, March, April) =TEXT(DATE(2000,A1,1),"mmm") for 3-letter Month Abbreviation (Jan, Feb, Mar, Apr) =TEXT(DATE(2000,A1,1),"mmmmm") for 1st letter of Month (J, F, M, A) Paste the formula in a blank cell to the side … Continue reading Convert Numbers into Month Names in Excel