Convert a monthnumber to text: 2 should become februari
 

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

Convert a monthnumber to text: 2 should become februari
 

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","ju l","aug","sep","oct","nov","dec")
with spelling of your preference.
--
Gary's Student


"Ricky Gibson" wrote:

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

Convert a monthnumber to text: 2 should become februari
 

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

"Gary''s Student" wrote:

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","ju l","aug","sep","oct","nov","dec")
with spelling of your preference.
--
Gary's Student


"Ricky Gibson" wrote:

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

Convert a monthnumber to text: 2 should become februari
 

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


"Ricky Gibson" wrote in message . ..
|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
|
|

Convert a monthnumber to text: 2 should become februari
 

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

"Niek Otten" wrote:

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


"Ricky Gibson" wrote in message . ..
|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
|
|

Convert a monthnumber to text: 2 should become februari
 

Thank you Niek,

I did not realize it is that simple.

Rick

"Niek Otten" wrote in message
...
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


"Ricky Gibson" wrote in message
. ..
|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
|
|