Hi,

I have a table if several columns. One of them is Invoice Date. I am using
Pivot Table to compile the data. I am trying to find out how many invoices
were issued in a particular month. First I convert the mm/dd/yy into mm/yy,
but the Pivot Table gave me the result as mm/dd/yy. Then I copied the mm/yy
and past special - value. Still I got mm/dd/yy on my Pivot Table.

Any suggestion in how can I get how many invoices were issued in a
particular month?

Thank you.

Rubem