dates on pivot table not right

W

Wanna Learn

Hello On the data sheet I formatted the dates as
custom mmm-yy example of results is Jul-09 BUT when I create a pivot table
using the data the dates show as 7/29/09
How do I correct this so that the dates and the totals show Jul-09
thanks
 
J

Jim Thomlinson

When you create a pivot table it reads the dates into pivot cache memeory. It
does not read the format of the dates into memory. On the pivot table right
click the dates and select
Field Settings... -> Number | Date | Select your format
 
W

Wanna Learn

Thanks Jim
The dates need to be and are in in the row section of the pivot table
following your instructions Number does not appear after selecting Field
settings...
I tried formatting the cells as text and that works except that now the
months are in alphabetical order and I need them to be year order by month
starting with Jan

thanks thanks
 
J

Jim Thomlinson

A couple of quick questions...
1. Your source data cells are true dates and there are no blanks in the list?
2. Which version of XL are you using. The Pivot table engine changed in XP.
When you Select Field Settings what buttons or such do you have as choices...
 
W

Wanna Learn

Again Thanks Jim
This morning I came in and when I selected field settings the number option
came up. It was not there yesterday. I have excel 2003 and it is on a
network.
Your solutions works. thanks
 

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

Top