winglessbuzzard
New Member
- Joined
- Jan 12, 2009
- Messages
- 29
I have a date field in a pivot table which is sourced from a list object table all within the same workbook. The slicer date format is 11/06/15. I want to change its format to 11/06. Things I have tried so far with no effect in the slicer date format:
- change the format of the all dates within the date field in the underlying pivot table, refresh the slicer
- change the date format in the underlying source data, refresh the pivot, refresh the slicer
- scour the internet for an hour