A1:A3 - enter 01/05/2007; 2/15/2007; 3/20/2007

Highlight A1:A3 Format, Cells, Custom, (In the Box enter) mmmm
Ok Gives you January, February March

B1:B3 =Month(A1); =Month(A2); =Month(A3)
Gives you 1 2 3

HTH

"Jordan" wrote in message
:

I have a list of all the months in Column A. ie: January - December. I need
to use the month in another formula. In otherwords in another formula I need
to know that "January" is 1 and "February" is 2. If there a way to format
Colm A so that I can enter 01/01/2007 but have it show as "January" or is
there another way to do it.

Thanks in advance for any help you might have.