Formatting Dates

[Guest]

I have a list of all the months in Colm 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.

 

[Guest]

format==>custom=>"mmm"

 

[Guest]

or "MMMM" if want full name

 

[Guest]

Thank You so much. I was using a cheater colm and this makes the formula
much cleaner.

 

[JMay]

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