Dec 05 2018 10:53 PM - edited Dec 08 2018 08:06 AM
Hello,
I have a this Pivot Table( Attached) - I need to display the Dates as (Jan-2018), when I change the Field setting (shown in the image) nothing changes!
could please tell me how to change the date format ? I don't want to change the format of the Data source.
thank you in advance
Dec 06 2018 07:00 AM
Hi
Your dates are grouped. Grouped dates are always text.
Ungroup your dates and they will become numbers again which you can format.