Extract the month name from a month
 

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

Extract the month name from a month
 

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.


"Grd" wrote:

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

Extract the month name from a month
 

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

On Feb 3, 2:45*pm, Grd wrote:
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

Extract the month name from a month
 

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


On Feb 3, 2:45*pm, Grd wrote:
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

Extract the month name from a month
 

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


"Grd" wrote:

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

Extract the month name from a month
 

Another one...

A1 = a number from 1 to 12

=TEXT(A1*29,"mmm")

--
Biff
Microsoft Excel MVP


"Grd" wrote in message
...
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

Extract the month name from a month
 

This method works for me.
Tx

"Mike H" wrote:

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.


"Grd" wrote:

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

Extract the month name from a month
 

Hi,

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

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

tx
Grd

"Teethless mama" wrote:

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


"Grd" wrote:

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

Extract the month name from a month
 

Works too!

Tx
Grd

"T. Valko" wrote:

Another one...

A1 = a number from 1 to 12

=TEXT(A1*29,"mmm")

--
Biff
Microsoft Excel MVP


"Grd" wrote in message
...
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


.

Extract the month name from a month
 

Thanks for the reply,

They all come out Jan. But the Ctrl+1 shortcut was great.

Tx
Grd

"JP" wrote:

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


On Feb 3, 2:45 pm, Grd wrote:
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

.

Extract the month name from a month
 

My bad. But it looks like others came in with the correct answer.

--JP

On Feb 3, 10:49*pm, Grd wrote:
Thanks for the reply,

They all come out Jan. But the Ctrl+1 shortcut was great.

Tx
Grd

Extract the month name from a month
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Grd" wrote in message
...
Works too!

Tx
Grd

"T. Valko" wrote:

Another one...

A1 = a number from 1 to 12

=TEXT(A1*29,"mmm")

--
Biff
Microsoft Excel MVP


"Grd" wrote in message
...
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


.