Pivot table showing date as month

[Sean15]

Hi:

How can I force Excel pivot table to show dates as m/d/yyyhyyy instead of month?

For example, if have several 9/30/2017 in column A, pivot table is displaying them as Sep

Could you help please?

Regards

Sean

 

[sandy666]

Options - Advanced - Data - Disable automatic grouping Date/Time columns in PivotTables -checked

 

[Sean15]

Thank you very much.

 

[sandy666]

U R welcome