Date in Pivot TAble

[ahmad ali]

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

[#2]

Hi

Your dates are grouped. Grouped dates are always text.

Ungroup your dates and they will become numbers again which you can format.

[#3]

thank you ... it's working