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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date is displaying 00-Jan-00 when I type in 11/16/09. 3
Pivot table & Date orders 2
Excel PRICE function: How does it compute Issue Date of the Security 5
2 dimensional date sort 1
Need help displaying odd numbered month 3
lookup help. lookup result based on data in 2 columns 3
index_match 5
Searching for records with multiple criteria 7

Back
Top