Convert a monthnumber to text: 2 should become februari

[Ricky Gibson]

I am using Excel 2002.
I have in column D the birthdate of persons (e.g.: 23-02-1962)
I extract in column E, with the MONTH-function, the month (2 in my example)
However I do not want the number 2, but the text februari.
How can I do that?

Thanks for any suggestions,
Rick

 

[Gary''s Student]

To get month as text:
=DATE(2006,E1,1) formatted as mmmm

To get month as text (any format)
=CHOOSE(A1,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec")
with spelling of your preference.

 

[Rookie 1st class]

Custom format E?? as "mmmm". Paste =D??.
Hth
Lou

To get month as text:
=DATE(2006,E1,1) formatted as mmmm

To get month as text (any format):
=CHOOSE(A1,"jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec")
with spelling of your preference.

 

[Niek Otten]

Don't extract the month. Just use
=D1
and format Custom as "mmmm"
If you require it to be text, use
=TEXT(D1,"mmmm")

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I am using Excel 2002.
| I have in column D the birthdate of persons (e.g.: 23-02-1962)
| I extract in column E, with the MONTH-function, the month (2 in my example)
| However I do not want the number 2, but the text februari.
| How can I do that?
|
| Thanks for any suggestions,
| Rick
|
|

 

[Rookie 1st class]

Reread it; do you want 23 Februari 1962?
if yes
in E# paste =D#
custom format E# as
dd mmmm yyyy
it wlll spell out the entire month as your regional setting does.
Hth
Lou

 

[Ricky Gibson]

Thank you Niek,

I did not realize it is that simple.

Rick