month name
in [Functions]
|
Prev: Partial Text Match then enter desired result into appropriate colu
Next: can you embed a worksheet within the cell of another worksheet?
From: pat67 on 24 May 2010 15:45 There is a function to show the number of the 1-12. Is there a way to show the name?
From: "David Biddulph" groups [at] on 24 May 2010 15:55 =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" <pbuscio(a)comcast.net> wrote in message news:a92ef0c0-a217-4c9f-bdfe-4d9f86d848a6(a)j27g2000vbp.googlegroups.com... > There is a function to show the number of the 1-12. Is there a way to > show the name?
From: pat67 on 24 May 2010 16:33 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" <pbus...(a)comcast.net> wrote in message > > news:a92ef0c0-a217-4c9f-bdfe-4d9f86d848a6(a)j27g2000vbp.googlegroups.com... > > > > > 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
From: Bernard Liengme on 24 May 2010 20:15 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 "pat67" <pbuscio(a)comcast.net> wrote in message news:a92ef0c0-a217-4c9f-bdfe-4d9f86d848a6(a)j27g2000vbp.googlegroups.com... > There is a function to show the number of the 1-12. Is there a way to > show the name?
From: T. Valko on 24 May 2010 20:36
>=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 news:O--dnfliNYspRGfWnZ2dnUVZ7o-dnZ2d(a)bt.com... > =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" <pbuscio(a)comcast.net> wrote in message > news:a92ef0c0-a217-4c9f-bdfe-4d9f86d848a6(a)j27g2000vbp.googlegroups.com... >> There is a function to show the number of the 1-12. Is there a way to >> show the name? > > |