is there a funciton that will return only the name of the month. IE
COL A COL B
12/3/2009 December
3/4/2007 March
and so on

in column B simply refer to column A and format col B as "mmmm"
So B2 has =A2 and is formatted as "mmmm".
Bob Umlas
Excel MVP

" wrote in message
...
is there a funciton that will return only the name of the month. IE
COL A COL B
12/3/2009 December
3/4/2007 March
and so on

Yes. Format the cell as Custom, in the Type box, enter "mmmm" (withour the
quotes)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

" wrote in message
...
is there a funciton that will return only the name of the month. IE
COL A COL B
12/3/2009 December
3/4/2007 March
and so on

wrote:
is there a funciton that will return only the name of the month. IE
COL A COL B
12/3/2009 December
3/4/2007 March
and so on


If you actually want the text "March" instead of a date formatted to show
"March", use the TEXT() function:

=TEXT(A1,"mmmm")