Formatting Question

On Wed, 2 Nov 2005 05:20:04 -0800, "Sandy" <Sandy@discussions.microsoft.com>
wrote:

>How do I convert a the numeric contents of a cell to its coresponding month
>A1=10
>A2=Oct
>SImple question but I cant seem to find the answer
>Thanks!
>

Look at HELP for the CHOOSE function:

=CHOOSE(A1,"Jan","Feb",...)


--ron

How do I convert a the numeric contents of a cell to its coresponding month
A1=10
A2=Oct
SImple question but I cant seem to find the answer
Thanks!

In A2: =date(2000,A1,1). Use a custom format: Format > Cells, on the
Number tab select the Custom category and enter "Mmm". That will get a date
(10/1/2000) in A2 and format it to appear as you want.
If you really need the value 'Oct', you'd probably create a table with month
numbers in one column, names in the second column, and use a vlookup formula.


"Sandy" wrote:

> How do I convert a the numeric contents of a cell to its coresponding month
> A1=10
> A2=Oct
> SImple question but I cant seem to find the answer
> Thanks!
>
>

thanks!

"bpeltzer" wrote:

> In A2: =date(2000,A1,1). Use a custom format: Format > Cells, on the
> Number tab select the Custom category and enter "Mmm". That will get a date
> (10/1/2000) in A2 and format it to appear as you want.
> If you really need the value 'Oct', you'd probably create a table with month
> numbers in one column, names in the second column, and use a vlookup formula.
>
>
> "Sandy" wrote:
>
> > How do I convert a the numeric contents of a cell to its coresponding month
> > A1=10
> > A2=Oct
> > SImple question but I cant seem to find the answer
> > Thanks!
> >
> >

On Wed, 2 Nov 2005 05:20:04 -0800, "Sandy" <Sandy@discussions.microsoft.com>
wrote:

>How do I convert a the numeric contents of a cell to its coresponding month
>A1=10
>A2=Oct
>SImple question but I cant seem to find the answer
>Thanks!
>

Look at HELP for the CHOOSE function:

=CHOOSE(A1,"Jan","Feb",...)


--ron