Prev: Formula for adding a cell in multiple workbooks
Next: count cells in a table that meet multiple criteria
From: Grd on 3 Feb 2010 14:45
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
From: Mike H on 3 Feb 2010 14:51
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
From: Mark on 3 Feb 2010 15:08
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 <G...(a)discussions.microsoft.com> 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

From: JP on 3 Feb 2010 15:11
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 <G...(a)discussions.microsoft.com> 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

From: Teethless mama on 3 Feb 2010 15:38
=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
 |  Next  |  Last
Pages: 1 2 3
Prev: Formula for adding a cell in multiple workbooks
Next: count cells in a table that meet multiple criteria