Remove underlying data in Dates.

[montanaaggie]

In column A, I have dates listed 3/28/2011, 4/7/2011, 12/25/2010, etc. I created column B and selected Column A and pasted the data in. I then went to Format Cells and selected date and chose the example "Mar-01" There are other columns in this sheet and created a pivot table. I wanted the months to be a column filter within the table. However what I'm seeing is multiple "Mar-11" because the data is different 3/15/2011, 3/23/2011, 3/1/2011.

How can I in the source data either format the cells or insert a new column that whipes out the underlying data only leaves me with the month and year?

 

[VoG]

You can Group the dates in a PT http://www.contextures.com/xlPivot07.html

Alternatively, instead of changing the format, use a formula like

=TEXT(A1,"mmm-yy")