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

"Toppers" wrote:

or "MMMM" if want full name

"Jordan" wrote:

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.