Hi,
I need to change the date formatting on a pivot table. The pivot table lists the dates by group, and i need just a straight column of dates in a mm/dd/yyyy format. I would just copy the pivot table and paste values, then change the top date to the mm/dd/yyyy format and copy down, but I have some dates missing in the data set, so when I do that it ends up placing false dates for the data points.
Kind of hard to explain... but basically i just need to change the date format in the pivot chart to the mm/dd/yyyy format, instead of the "grouped by year" formatting
Thanks
Bookmarks