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.
=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.