Prev: Formula for adding a cell in multiple workbooks
Next: count cells in a table that meet multiple criteria
From: T. Valko on 3 Feb 2010 16:58
Another one...

A1 = a number from 1 to 12

=TEXT(A1*29,"mmm")

--
Biff
Microsoft Excel MVP


"Grd" <Grd(a)discussions.microsoft.com> wrote in message
news:31E393B8-E567-44BA-8898-EAE77F5B116C(a)microsoft.com...
> 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: Grd on 3 Feb 2010 22:40
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
From: Grd on 3 Feb 2010 22:47
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
From: Grd on 3 Feb 2010 22:48
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" <Grd(a)discussions.microsoft.com> wrote in message
> news:31E393B8-E567-44BA-8898-EAE77F5B116C(a)microsoft.com...
> > 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: Grd on 3 Feb 2010 22:49
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 <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
>
> .
>
First  |  Prev  |  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