Hi,

It looks as though your dates are not Excel dates but text enties. You must
convert them to date. The following might work:

Select an empty cell and choose Copy
Select all the dates in the data source, not the pivot table and choose
Home, Paste, Paste Special, Add.

If this works you will want to format the cells as dates.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"celli57" wrote:

Hope someone can help - I am trying to create a pivot table of data which
covers 9 years and the first thing I want to do is sort the date into months
and quarters. When I take the date across to the table and try to group them
it is telling me I cannot group the selection and I notice the dates are
listed as
1/1/2000
1/1/2001
1/1/2002
1/1/2003
1/1/2004
1/1/2005
etc then the next day follows again sorted by each year. Any suggestions
would be welcome

Thanks