Excel help - displaying number as a month

[chrismox]

Is there any easy way of displaying a number as a month without using a long IF formula?

For example, if the value of a cell is "11", how can I get excel to display it as "November"?

The MONTH function seems to display "11" as "January" (it appears to think that it's the 11th day, not the 11th month.

Cheers.

 

[chrismox]

I can't seem to create a working custom date option - it always reverts to believing the number is the day rather than the month.

 

[chrismox]

Thanks but managed to do it another way:

A1="11" (for example)
=DATE(2000,A1,1) returns the date "1st November, 2000"
Format that as "mmmm" displays simply "November"