If you don't want a numeric display use a custom number format mmm.

This will return display as Mar for 3/1/2010
--
If this helps, please remember to click yes.


"Kennedy" wrote:

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.