I don't think you're gonna be able to use formatting for this.

But you could use a helper cell:

=date(2005,a1,1)
if A1 contained the month number.

Format this cell as MMMM
and you can keep the value as a real date.

or
=text(date(2005,a1,1),"MMMM")
If you want the text string for the month.


Phil Hart wrote:

I'm trying to format a field in an Excel Spreadsheet in such a way that it
displays a month name rather than a month number.

For Example, if a cell contains 8, I want the cell to show as August.

Conditional formatting only allows me 3 levels of condtions and isn't
therefore suitable.

--

Dave Peterson