Well, day two and I have another issue dealing with the same data I have been using in another posting.
I am working with a Pivot Table trying to sum a range of data by years. The data is entered as mm/yy. When I try to group the data together by year to get a sum for that year, the grouping changes the date, but incorrectly.
For example:
00
01
02
99
These dates change to:
1900
1901
1902
1999
I have checked my cell content and the cells are Custom/mmdd.
Any suggestions?
Thanks again,
Jason
I am working with a Pivot Table trying to sum a range of data by years. The data is entered as mm/yy. When I try to group the data together by year to get a sum for that year, the grouping changes the date, but incorrectly.
For example:
00
01
02
99
These dates change to:
1900
1901
1902
1999
I have checked my cell content and the cells are Custom/mmdd.
Any suggestions?
Thanks again,
Jason