Spikenaylor
Board Regular
- Joined
- Apr 14, 2013
- Messages
- 115
- Office Version
- 365
- Platform
- Windows
I have my pivot table set up
One of the row labels is a date field, however I cannot get it to stay in the date format I wish, it keeps defaulting to dd/mm/yyyy
The source column is set to format dd mmm yyyy.
Every time I try something to change to date format in the pivot table, it defaults back again.
any pointers or help out there.
many thanks
One of the row labels is a date field, however I cannot get it to stay in the date format I wish, it keeps defaulting to dd/mm/yyyy
The source column is set to format dd mmm yyyy.
Every time I try something to change to date format in the pivot table, it defaults back again.
any pointers or help out there.
many thanks