View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ricky Gibson Ricky Gibson is offline
external usenet poster
 
Posts: 4
Default 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