grouping dialog box
 

I am working in pivot table and want to group my dates into months, but
cannot find, why the grouping dialog box is not available

grouping dialog box
 

If there are any blank cells in the date column, you won't be able to
group the dates in the pivot table.

http://www.contextures.com/xlPivot07.html

Or, if the dates are being treated as text, you won't be able to group
them. If so, you can change the dates back to numbers, as described he

http://www.contextures.com/xlDataEntry03.html


Marion wrote:
I am working in pivot table and want to group my dates into months, but
cannot find, why the grouping dialog box is not available


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

grouping dialog box
 

Thanks, opened new worksheet and found error, date setting to the regional
setting on PC did not agree.

"Debra Dalgleish" wrote:

If there are any blank cells in the date column, you won't be able to
group the dates in the pivot table.

http://www.contextures.com/xlPivot07.html

Or, if the dates are being treated as text, you won't be able to group
them. If so, you can change the dates back to numbers, as described he

http://www.contextures.com/xlDataEntry03.html


Marion wrote:
I am working in pivot table and want to group my dates into months, but
cannot find, why the grouping dialog box is not available


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html