Web Talk

If you work with Microsoft Office Excel you know that one of the most used formula is the MONTH() which lets you add the month of a certain date as a number (ex. 02/06/2012). However, certain users might prefer the month to be shown as a text instead of a number (ex. February o6 2012). This quick formula will let you show and convert any month date number to month text.

1. Open Office Excel.
2. Copy and paste the following formula to your Excel sheet: =TEXT(DATE(YEAR(A1), MONTH(A1), DAY(A1)), “mmmm”) . Let’s see what this formula means:
   • The TEXT word at the beginning will return text date instead of number date.
   • Year is the year.
   • A1 is the name of the cell  where the text year is located.
   • Month is the first day of the month.
   • A1 is the name of the cell  where the text month is located.
   • “mmmm” defines how the month is displayed.
3. Here is how you can customize the month:
   • mmmmm = Shows the  first letter of the month.
   • mmmm = Displays the full month text.
   • mmm = Displays the first 3 letters of  the month.
4. Done!