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