stop Date Fields from automatically grouping in pivot fields

[TrimFunction]

This issue started when I upgraded to Excel 2016 32bit.

I use multiple date fields ('decision date' or 'close date' formatted like 10/20/2018) in the column field in a tabular pivot table.

Excel automatically groups these, and i need the date to be in one column,not grouped by month/etc.

I've tried account options (which i think is only for the current workbook) and the dword registry, but i havent solved this.

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...elds-automatically-grouping-pivot-fields.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it. Please be patient and do not attempt to post the question again.