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