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
--
HTH...

Jim Thomlinson


"Wanna Learn" wrote:

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