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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table problem 4
convert date to text month 2
Pivot Table - month groups 2
Information for Pivot Table 3
Pivot Table Grouping 1
data in formula and how to use pivot table 4
Convert Date to MMYY format 2
If statement with dates 0

Back
Top