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!