Month function

  • Thread starter Thread starter ispy1009
  • Start date Start date
I

ispy1009

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.
 
I assume you have a month numeric in a cell which you are trying to display
as month text. Try

=DATEVALUE("2009-" & A1 & "-1")
(and format it to "mmm")

If this post helps click Yes
 
If a cell has a date in it, then mm will display the month number and mmm
will display the month as text.

If a cell has a simple number like 1, 2, 3,......., then the formula:
=DATE(2009,A1,1) will also display the month as text if formatted as mmm.
 
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.
 
Back
Top