Excel help - displaying number as a month

chrismox · 17 Nov 2006 at 19:37

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.

Echo toxin · 17 Nov 2006 at 19:50

Can you not create a custom date option?
Press CTRL+1 and it's on one of those tabs somewhere.

chrismox · 17 Nov 2006 at 20:13

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.

RikWebb · 17 Nov 2006 at 20:16

chrismox said:
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.

If memory serves me correct: and I will be vauge here!

You need to create a custom list ???

Look up custom lists
As I said Im not sure, but it seems to ring a bell. Its been a long time!!

Rik

chrismox · 17 Nov 2006 at 20:28

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"