Forum Discussion
Re: Cannot group that selection in a pivot table
I have a similar problem and have followed the instructions that you have provided but did not get a win 
FYI Pivot table data source is set to include row 39.
Pivot table filter displays the 0 however does not recognise date format.
1 Reply
Simon_FishWell, the fact that the filter dialogue box says you can Sort A to Z or Z to A suggests that you are dealing with texts that merely look like dates. With real dates it will say:
Select the 'dates' in P2:P39. Then, on the Data ribbon select Text-to-columns and press Finish. So, just Finish. change nothing. That should convert the text dates into real dates. Refresh the pivot table and it shall work.
Save your file first, though, so that you don't loose your data if it goes wrong.
