Bookmark and Share

ExcelIf 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!

Related Tags

  • excel formula to change date to text month
  • viewed month into text excel
Related Articles Latest Articles

One Comment to “How to Convert Date Number To Month Text in Excel”

  1. Shailesh Says:

    Excellent help, please keep it up

Copyright © 2007-2017 | Sitemap | Privacy | Back To Top
Best screen resolution 1280x800 or higher.
Web Talk is best viewed in Firefox.