Because of the way Excel interprets dates, the number 8, by itself,
cannot be formatted as August. You can, however, use a helper column
to generate your desired output. Place this formula in your helper
column and FormatCustomMMMM

=(A1&"/01/2005")*1

If A1=8, "August" is returned
If A1=12, "December" is returned.

Adjust the cell reference as needed.

Good Luck.

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=380533