Pivot Table Date Format

G

Guest

I create a pivot table where the date format from the source data is ENTERED
as mm/dd/yyyy. (1/30/2007) I change the format display in the source data to
dd-Mmm-yy (01-Jan-07). When I create the pivot table, the format is
mm/dd/yyyy. (1/30/2007). OK, same as source data. I want the pivot table
format to be dd-Mmm-yy (01-Jan-07). I can change the format in the pivot
table, but when I refresh the table, the format reverts back to mm/dd/yyyy.
I've tried every combination of Autoformat table and preserve formatting in
the options screen but get the same results. What do I need to do? Thanks.
 
D

Debra Dalgleish

Right-click the Date field button, and choose Field Settings
Click the Number button, and select the date format you want
Click OK, click OK.
 
G

Guest

Debra, Thanks, I tried your recommendation. The problem is when I refresh
the tables (I have dozens tied to the same spreadsheet) the dates revert back
to the original format. I want to avoid having to change date format
everytime I refresh the tables. Any suggestions?
Cliff
 

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

counting records by month and year / date format issues 1
Pivot Table date format 1
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Changing date to eliminate day in format mm/dd/yyyy 1
date 2
Date prob with Pivot Table 1
Pivot Table - month groups 2
Convert Date to MMYY format 2

Top