One way...

A1 = a date like 03/01/2010

B1 formula:

For the short month name like Mar

=TEXT(A1,"mmm")

For the long month name like March

=TEXT(A1,"mmmm")

--
Biff
Microsoft Excel MVP


"Kennedy" wrote in message
...
Is there a way to convert a numeric date 03/01/2010 into a single month
function? I have a worksheet that pulls in data from another worksheet,
and
column A has a numeric date of 03/01/2010. Want to put a statement in
column
B or where that only shows the month instead of the whole date field.