View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Liz J[_2_] Liz J[_2_] is offline
external usenet poster
 
Posts: 36
Default Changing the Format of a Date

I have dates in Column A in this format: MM/DD/YYYY and I would like to
insert a column (column B) that would extract the month indicated in column
A. For example, cell A2 says: 3/19/2008, in cell B2 I would like it to say
"March." How would I do that in Excel?

Thanks for your help!