month name

  • Thread starter Thread starter pat67
  • Start date Start date
If a cell is displaying a date (let's say 1/1/2010) and I give it the custom
format of "mmm" (without quotes) will display the month name abbreviation
A custom format of "mmm" will display the full name
Suppose A1 holds a date and B1 has =A1, then the custom formatting will show
the name of month as above
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

REMEMBER: Microsoft is closing the newsgroups; We will all meet again at
http://answers.microsoft.com/en-us/office/default.aspx#tab=4
 
=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1

If you have just the month number 1 to 12:

=TEXT(A1*29,"mmmm")
 
Back
Top