15
Oct
2010



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!

Tags: ,


Related ArticlesLatest Articles
.

Leave a Comment

If you want to show an image next to your comments, get your gravatar now!

This blog is moderated. Inappropriate comments will be edited or removed. Users posting offensive comments will be banned from this blog. Report Inappropriate Comments Here.

XHTML - You can use the following tags:  <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>


Users Important Words

excel month as text - calc openoffice function convert date in year month day - formula for month and year in excel - excel 2010 convert date to month - excel month text 2007 - excel translate date to month/year - excel translate month number to text - excell formula to show month as text -

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

Stat