Formatting Question

[Guest]

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!

 

[Guest]

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.

 

[Guest]

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.

 

[Ron Rosenfeld]

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