C Claude Nov 28, 2003 #1 hi everyone If I use month() I get a serial 1-12 as output. Is there a formula to get output "january" ?
hi everyone If I use month() I get a serial 1-12 as output. Is there a formula to get output "january" ?
D David McRitchie Nov 28, 2003 #2 Hi Claude, use cell formatting format, cell, custom, mmmm you will still have the complete date value it is just the display that is affected. --
Hi Claude, use cell formatting format, cell, custom, mmmm you will still have the complete date value it is just the display that is affected. --
H Harald Staff Nov 28, 2003 #4 Or, if you really want the text as real text, not a formatted date: =TEXT(A1,"mmmm")
C Claude Nov 28, 2003 #5 Thanks Harald, this is what I need! -----Original Message----- Or, if you really want the text as real text, not a formatted date: =TEXT(A1,"mmmm") -- HTH. Best wishes Harald Followup to newsgroup only please "Claude" <[email protected]> skrev i melding . Click to expand...
Thanks Harald, this is what I need! -----Original Message----- Or, if you really want the text as real text, not a formatted date: =TEXT(A1,"mmmm") -- HTH. Best wishes Harald Followup to newsgroup only please "Claude" <[email protected]> skrev i melding . Click to expand...
R Ron Rosenfeld Nov 28, 2003 #6 hi everyone If I use month() I get a serial 1-12 as output. Is there a formula to get output "january" ? Click to expand... In addition to what others have written, if you really want to have that serial number, you could also use the CHOOSE function: =CHOOSE(MONTH(),"January","February","March", ... ) --ron
hi everyone If I use month() I get a serial 1-12 as output. Is there a formula to get output "january" ? Click to expand... In addition to what others have written, if you really want to have that serial number, you could also use the CHOOSE function: =CHOOSE(MONTH(),"January","February","March", ... ) --ron
