Formating MONTH()

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?
 
A

akphidelt

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")
 
R

Rick Rothstein \(MVP - VB\)

Use this instead...

=TEXT(A1,"mmm")

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

=TEXT(A1,"mmmm")

Rick
 
K

krcowen

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
 
M

Matt S

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

Matt S

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

Matt S

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

Matt S

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

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

COnverting Weeks into Month (text data) 1
Excel PRICE function: How does it compute Issue Date of the Security 5
HOW TO INPUT MONTHLY ACCUMULATED SALARY IN MS PROJECT? 0
Incone & Expenses Statement 0
Date is displaying 00-Jan-00 when I type in 11/16/09. 4
Excel file won't save to iCloud on Mac 0
Help showing active months between two dates 5
Pivot table & Date orders 2

Top