View Single Post
  #1   Report Post  
Snakeoids
 
Posts: n/a
Default 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