If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
month name
There is a function to show the number of the 1-12. Is there a way to
show the name? |
#2
|
|||
|
|||
month name
=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 "pat67" wrote in message ... There is a function to show the number of the 1-12. Is there a way to show the name? |
#3
|
|||
|
|||
month name
On May 24, 3:55*pm, "David Biddulph" groups [at] biddulph.org.uk
wrote: =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 "pat67" wrote in message ... There is a function to show the number of the 1-12. Is there a way to show the name?- Hide quoted text - - Show quoted text - Thanks |
#4
|
|||
|
|||
month name
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/o...ult.aspx#tab=4 "pat67" wrote in message ... There is a function to show the number of the 1-12. Is there a way to show the name? |
#5
|
|||
|
|||
month name
=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") -- Biff Microsoft Excel MVP "David Biddulph" groups [at] biddulph.org.uk wrote in message ... =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 "pat67" wrote in message ... There is a function to show the number of the 1-12. Is there a way to show the name? |
Thread Tools | |
Display Modes | |
|
|