P
pat67
There is a function to show the number of the 1-12. Is there a way to
show the name?
show the name?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
David Biddulph
=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
=TEXT(A1,"mmmm") if you've got the date in A1
P
pat67
=TEXT(DATE(2010,A1,1),"mmmm") if you've got 1-12 in A1
=TEXT(A1,"mmmm") if you've got the date in A1
--
David Biddulph
- Show quoted text -
Thanks
B
Bernard Liengme
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
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
T
T. Valko
=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")
If you have just the month number 1 to 12:
=TEXT(A1*29,"mmmm")