Formatting Question

S

Sandy

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!
 
B

bpeltzer

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.
 
S

Sandy

thanks!

bpeltzer said:
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.
Click to expand...
 
R

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!
Click to expand...

Look at HELP for the CHOOSE function:

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


--ron
 
Top