hi,
so i'm new to excel 2010, but well familiar with older versions.
i have date fields that I pull into a pivot chart to sort by. then i right click on the date in the pivot table in order to open the grouping dialog box. this all seems the same as excel 2003.
but the data range for the grouping is showing as the 1900 serial, not a 'date'. so the grouping option is by default '10', which makes no sense for monthly data.
i've gone over the change format prior to the grouping, and the date displays as a date in the pivot table.
not sure where to go from here. need to have the dialog box recognize the data as dates so i can group properly.
thanks
Bookmarks