MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert Excel Dates to Month Names


September 01, 2014 - by Bill Jelen

Need to Subtotal or Group by Month?

Convert Excel Dates to Month Names
Convert Excel Dates to Month Names

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.