Pivot Table Change Date Format. That should fix it. The problem here is that excel doesn t store this value as date or number but as text.
When i follow the same steps as described below there is no number format button showing in the field settings dialog see screen copy below why is that. Right click a date in the pivot table not the pivot chart. We can group items in a following way.
We will ungroup date we will right click on any cell in the date field of the pivot table we will select field settings number format.
The problem here is that excel doesn t store this value as date or number but as text. In the pivottable select a row field. We can group items in a following way. I managed to change the date format within the pivot table using ungroup but this new format does not get reflected in the pivot.
