In an empty column adjoining your data, try:
=TEXT(F2,"mmm")
and copy down.

Hope this helps,

Hutch

"HL" wrote:

I have a column with the following information:
F2=1/3/2010
F3=1/15/2010
F4=2/14/2010
and so on

I'm creating a Pivot Table to display this information and right now it
shows each week. I really want to the Pivot Table to show the data based on
the month.

How do i take the information above (e.g. 1/3/2010) and create a column that
will only show Jan, Feb, Mar, etc.

So essentially i want to say IF F2=mm/dd/yyyy then G2=Jan

thanks