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 of the fist number
  • Change “A1” to the cell the first number is in
  • Copy the cell formula
  • Highlight down the length of the list & Paste
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s