how do I troubleshoot date formats in a pivot table report?

The date format appears only with the month (e.g. Jan) and not the year, even
though I have formatted the cells to show, e.g. Jan-05.

Mark

You shouldn't need to format the date for a year. If you right-click on the
date header and select Group and show detail>Group... you will then be able
to select months and years. This will add a new field with the year in it.
If you have data from multiple years then Excel will aggregate all the
January's data for example unless you tell it to show years.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"Mark Hunt" <Mark [email protected]> wrote in message
news:[email protected]...
> The date format appears only with the month (e.g. Jan) and not the year,
> even
> though I have formatted the cells to show, e.g. Jan-05.