I am sure there are easier ways, but here are 2 ways that work:

=IF(AND(A2=1,A2<=12,A2=INT(A2)),TEXT(A2&", 2008","mmmm"))

or if you are really a glutton for punishment.
(you could add the same error handling as in the IF statement above).
=CHOOSE(A2,"January","February","March","April","M ay",June","July","August","September","October","N ovember","December")
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"dkholmes50" wrote:

I have populated many cells in column A with the numbers 1 through 12. The
numbers are synonymous with the months of the year. However, I would like to
enter a formula in a cell in column B that looks at a cell in Column A,
determines which number is the cell and then populate the actual month in a
cell in column B. So if the number 12 was in cell A250, I would like the
formula B250 to look at cell A250, identify that it is populated with the
number 12 and then populate cell B250 with the word December. I would like to
run the formula on the entire list in Column A. So theoretically, each month
will appear in Column B because of the list of numbers 1 through 12 in column
A. How do I do this?