Change Date Values
 

Greetings,
I've created a pivot table that has dates along the top and quantities sumed
in the data field. The problem is that Excel is not combining the date like
I want. I want the date columns at the top to be distince my month-year, but
excel is distinct for full date. To give an example. I have columns for
January 2004 such as this:

01/01/04 01/02/04 01/03/04

I want a single column for January 2004 with quantities added together and
not seperated by the day. Please help. Thank you.
Rod Neville

Change Date Values
 

Select one of those headers and right click on it.
Choose Group and show detail
Group by month (and probably years???).



Snakeoids wrote:

Greetings,
I've created a pivot table that has dates along the top and quantities sumed
in the data field. The problem is that Excel is not combining the date like
I want. I want the date columns at the top to be distince my month-year, but
excel is distinct for full date. To give an example. I have columns for
January 2004 such as this:

01/01/04 01/02/04 01/03/04

I want a single column for January 2004 with quantities added together and
not seperated by the day. Please help. Thank you.
Rod Neville

--

Dave Peterson