The MONTH function returns a number from 1 to 12 (see Excel help for the
MONTH function).
If you format a cell containing a number from 1 to 12 as mmm or mmmm it
will, of course, show as January, as the dates represented by numbers 1 to
12 are 1 Jan 1900 to 12 Jan 1900. If you want to format as mmm or mmmm, do
that to the date you started with, not to the output of the MONTH function.
--
David Biddulph

"ispy1009" wrote in message
...
In using the month function I have encountered the following problem with
formatting. If I format the cells general or mm, I get the corresponding
digit to reflect the correct month. However, If I use "mmm" or "mmmm", I
get
Jan or January no matter what month. How can I format this column using
mmm
or mmmm and get the correct result? I am using Office 2003. I would like
to
have the month spelled out instead of just the digit(s) that reflect the
month.