GTretick
Member
I've created an example Pivot table that has a few categories in a table that feeds into a Pivot Table.
The date formatting in the Table is set to mmm d, yyyy and in fact appears that way.
The pivot table shows the formatting as mmm d, yyyy but instead appears as d-mmm.
I've tried playing around to change it but nothing seems to change the formatting.
Is it possible to change the formatting or am I stuck?
If so, what are the steps?
Thanks.
The date formatting in the Table is set to mmm d, yyyy and in fact appears that way.
The pivot table shows the formatting as mmm d, yyyy but instead appears as d-mmm.
I've tried playing around to change it but nothing seems to change the formatting.
Is it possible to change the formatting or am I stuck?
If so, what are the steps?
Thanks.