How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. as
the result for my = MONTH ( ) function?

If you have a date in A1:

=TEXT(A1,"mmm")

HTH,
Paul

--

"Matt S" wrote in message
...
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")

"Matt S" wrote:

How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. as
the result for my = MONTH ( ) function?

Use this instead...

=TEXT(A1,"mmm")

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

=TEXT(A1,"mmmm")

Rick


"Matt S" wrote in message
...
How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc.
as
the result for my = MONTH ( ) function?

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


On May 16, 3:58*pm, Matt S wrote:
How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. *as
the result for my = MONTH ( ) function? *

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

" wrote:

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


On May 16, 3:58 pm, Matt S wrote:
How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. as
the result for my = MONTH ( ) function?

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

"Rick Rothstein (MVP - VB)" wrote:

Use this instead...

=TEXT(A1,"mmm")

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

=TEXT(A1,"mmmm")

Rick


"Matt S" wrote in message
...
How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc.
as
the result for my = MONTH ( ) function?

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

"PCLIVE" wrote:

If you have a date in A1:

=TEXT(A1,"mmm")

HTH,
Paul

--

"Matt S" wrote in message
...
How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc.
as
the result for my = MONTH ( ) function?

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

"akphidelt" wrote:

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

"Matt S" wrote:

How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. as
the result for my = MONTH ( ) function?