Now that I went from 4/20/2010 to April-10 I still have a hard time filtering
my data.

Eventhough it says April-10 it is still reading the day because the original
date had the day in it. So it is filtering the days seperatly. If I have
two dates: 4/19/2010 in row 1 and 4/20/2010 in row 2, I want to change their
format to MM-YY so I would only count 1 but it is currently counting the two
dates seperatly in my pivot table. Please help me....


"David Biddulph" wrote:

You'll have to change them from text to a date. Try Data/ Text to Columns/
and set the import format as MDY.
--
David Biddulph


"Stross002" wrote in message
...
I have a column of dates that are formatted like: 04/19/2009.

BUT

I want them formatted as: April, 2009

I cright click and try to format the date but nothing happens?

Why? How can I change the format of these dates?

I am using Excel 07


.