month()

[Claude]

hi everyone
If I use month() I get a serial 1-12 as output. Is there a
formula to get output "january" ?

 

[David McRitchie]

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.
--

 

[Andy B]

Claude

Format the cell as mmmm

Andy.

 

[Harald Staff]

Or, if you really want the text as real text, not a formatted date:

=TEXT(A1,"mmmm")

 

[Claude]

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


.

 

[Ron Rosenfeld]

hi everyone
If I use month() I get a serial 1-12 as output. Is there a
formula to get output "january" ?

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