Convert a monthnumber to text: 2 should become februari

  • Thread starter Thread starter Ricky Gibson
  • Start date Start date
R

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
 
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.
 
Custom format E?? as "mmmm". Paste =D??.
Hth
Lou

Gary''s Student said:
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.
Click to expand...
 
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
|
|
 
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
 
Back
Top