View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Formatting Dates

format==custom="mmm"

"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.