Using a number stored as text in a calculation (a1*2/2) will coerce the value to
a number in that calculation. So using =isnumber() would be a better test.

IIRC, I've copied the data to another worksheet and recreated the pivottable and
it's worked ok. (I think!)

Sometimes, excel seemed to remember that a cell used to be text and just
wouldn't let go--(It's been a long time, but I think that was what worked.)

mattgoof2005 wrote:

I just used a =if(isblank(A2),1,0) and drug it over an area equal to that of
the data and its sum was zero, so it's safe to assume there are no blanks
anywhere in the data.

I also multiplied the date field by 2 and then averaged the column (since
this would return a #value error if any of the dates were text) and got a
valid date back.

Therefore, I think it's safe to assume that the conditions you specified for
failure are not met.

I've also noticed that there is a (blank) option under every field-arrow in
the pivot table.

"Dave Peterson" wrote:

If you have any text or empty cells in that date field, you won't be able to
group it.

mattgoof2005 wrote:

I have a huge list(24808RX14C) forming a pivot table. For some reason, when
I right-click on the dates and go to grouping, it says "Cannot group this
selection." There is only 1 date in each month (cost collection day), but I
would like to group it by Year-Month. Any ideas on why this is happening?

--

Dave Peterson


--

Dave Peterson