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