Extract the month name from a month

  • Thread starter Thread starter Grd
  • Start date Start date
G

Grd

Hi there,

I have a month column with just a number like 1 , 7 etc. I'd like to see Jan
instead of 1 and Jul instead of 7. Is there a formula for function for this.
There is only one number in a column at one time.

Any help would be greatly appreciated.

Tx

Grd
 
Hi,

With numbers (1 - 12) in column A us this and drag down

=DATE(2010,A1,1)

Format these cells with a custom format of mmm


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
You could use the month column in the DATE function and then use the
TEXT function to extract just the 3 letter month as in:

=TEXT(DATE(0,A1,1),"mmm")
 
If there is just a number in a single cell, just format it to look
like a month name.

In Excel 2003, select the cell, press Ctrl+1, go to Number tab, click
"Custom" and in the Type box, enter "mmm" (without quotes).

--JP
 
This method works for me.
Tx

Mike H said:
Hi,

With numbers (1 - 12) in column A us this and drag down

=DATE(2010,A1,1)

Format these cells with a custom format of mmm


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
Click to expand...
 
Hi,

I had to add "-2010" instead of just "-10" but that worked.

=TEXT(A1&"-2010","mmm")

tx
Grd
 
Back
Top