Convert Excel Dates to Month Names

September 01, 2014 - by Bill Jelen

Need to Subtotal or Group by Month?

The TEXT function will take any number or date and convert it to text using a particular custom number format.

Try these:

• =TEXT(A2,"MMMM") for full month name
• =TEXT(A2,"MMM") for 3-letter month abbreviation
• =TEXT(A2,"DDDD") for full month name
• =TEXT(A2,"DDD") for 3-letter month abbreviation

You can use any valid custom number format, even the ones with three zones for positive, negative, and zero. If the custom number format already contains a quotation mark, change it to two quotation marks:

=TEXT(B4,"""Please remit “"$#,##0.00;""Credit balance of “"$#,##0.00;""Zero Balance""")

This is one of the tips in Learn Excel 2007-2010 from MrExcel – 512 Excel Mysteries Solved.