C
Claude
hi everyone
If I use month() I get a serial 1-12 as output. Is there a
formula to get output "january" ?
If I use month() I get a serial 1-12 as output. Is there a
formula to get output "january" ?
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 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.
--
use cell formatting
format, cell, custom, mmmm
you will still have the complete date value it is just the display
that is affected.
--
A
Andy B
Claude
Format the cell as mmmm
Andy.
Format the cell as mmmm
Andy.
H
Harald Staff
Or, if you really want the text as real text, not a formatted date:
=TEXT(A1,"mmmm")
=TEXT(A1,"mmmm")
C
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
.
R
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