Grouping DATES in a pivot tables
 

In the past I've imported 3rd party data via ODBC into a pivot table ('SS1')
& have successfully grouped the DATE field into columns eg: Jan, Feb etc.
However I now need to add on intermediate spreadsheet ('SS2') to rearrange
the data from SS1 and convert text fields into values etc. I want to produce
a revised pivot from SS2. My problem is that the DATE record from SS1 now
appears as a date/time record in SS2 and will no longer group. I've tried all
sorts of formating etc but still get the "can't group that selection"
message. Any ideas? Many thanks.
--
Peter
London, UK

Grouping DATES in a pivot tables
 

It must be text, try this

=ISTEXT(x)

where x is a cell with these date/time values

if it returns TRUE it is text and you cannot group text,
if you copy an empty cell (formatted as dates), select the values and do
editpaste special and select add it should convert it to dates

--
Regards,

Peo Sjoblom


"Peter" wrote in message
...
In the past I've imported 3rd party data via ODBC into a pivot table
('SS1')
& have successfully grouped the DATE field into columns eg: Jan, Feb etc.
However I now need to add on intermediate spreadsheet ('SS2') to rearrange
the data from SS1 and convert text fields into values etc. I want to
produce
a revised pivot from SS2. My problem is that the DATE record from SS1 now
appears as a date/time record in SS2 and will no longer group. I've tried
all
sorts of formating etc but still get the "can't group that selection"
message. Any ideas? Many thanks.
--
Peter
London, UK