Formating MONTH()

  • Thread starter Thread starter Matt S
  • Start date Start date
M

Matt S

How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. as
the result for my = MONTH ( ) function?
 
Suppose you have the date in A1 and you want to get the month name in B1...
in b1 put the formula

=Text(A1,"mmmm")
 
Use this instead...

=TEXT(A1,"mmm")

and if you want the full month name, this...

=TEXT(A1,"mmmm")

Rick
 
Matt

Format the cell with a custom data format "mmm". You can do that in
the cell that contains the date, or in the cell that has the =MONTH()
function but you need to skip the =MONTH() function and have that cell
equal the cell with the date rather than the MONTH of the cell with
the date, as long as you format the final cell with "mmm". Once you
convert to a month number (1-12) you will always get Jan when you
format is as "mmm".

Good luck.

Ken
Norfolk, Va
 
Thanks to all. I got it. Can't use TEXT(Month( ),"mmmm") but TEXT ([date
cell],"mmmm") works just fine.
 
Thanks to all. I got it. Can't use TEXT(Month( ),"mmmm") but TEXT ([date
cell],"mmmm") works just fine.
 
Thanks to all. I got it. Can't use TEXT(Month( ),"mmmm") but TEXT ([date
cell],"mmmm") works just fine.
 
Thanks to all. I got it. Can't use TEXT(Month( ),"mmmm") but TEXT ([date
cell],"mmmm") works just fine.
 
Back
Top