Displaying 1-12 numbers as months of the year

[Mary90]

Hi guys

I have a graph that uses the actual numbers 1-12 to display months, but I'd like the data label to display the month written out as text.

Since the number must stay as an integer between 1 and 12, I cannot use date type formulae, since they then need the number to become a date number. Is there a way to create a number format to do this? "mmm" will obviously not work. (i.e., 12 should be "December" and not "12 Jan 1900" as it will currently be interpreted as)

Thanks!

 

[anthonyexcel]

Thanks Rick. I appreciate your explanation. As jonmo1 said it is a neat trick!

 

[Rick Rothstein]

Thanks Rick. I appreciate your explanation. As jonmo1 said it is a neat trick!

You are welcome. I came up with the idea for that "trick" probably about 10 or so years ago back when I was volunteering answering questions for the compiled version of Visual Basic. If you are familiar with VB/VBA programming, the "trick" works using VB's Format function in the same way as it works in Excel using the TEXT function...

MsgBox Format(28 * MonthNumber, "mmmm")