Hi,

I have data that i use to make a pivot table, the data contains dates as
mmm-yy but the pivot table shows them as 1/2/07, 2/2/07 etc.. it shows me
each day in the month! i do not want this. i just want it to give me a total
of how many of each thing there is per month (for example, aug07 total = 20)-
i do not want to know how many there was on 1/2/07 and then the next day etc.

please help, this is urgent!

thanks!!