Pivot Table group problem

[gpd]

I am attempting to group dates in a pivot table and receive the message "can not group that selection". The number format is general; I have also tried as number.The numbering format is 20090801, 20090802, 20090803.... I have tried as row and as column. What am I doing wrong?

Thanks

[DonkeyOte]

Although the original this post has since been duplicated (different forum) and subsequently responded to - as such this will be treated as the duplicate and locked down.

Note: Rule 5 of our forum rules.

Please ensure you read and adhere to the Forum Rules going forward... if you need a Thread moved simply PM a Mod who can do this for you.