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