Date prob with Pivot Table

G

Guest

The spreadsheet I'm using for a pivot table contains a calculated date field
(Date+30). This NewDate field is used in the pivot table. I've changed the
date format in both the data spreadsheet and the pivot table to mm/dd/yy, but
when the table is refreshed the NewDate field reverts to mm/dd/yyyy hh:mm. I
imagine this has to do with the calculation... What can I do so that I the
table can be refreshed, but keep the mm/dd/yy format?

Thanks in advance,
Janice
 
D

Debra Dalgleish

In the pivot table, right-click on the NewDate field button
Choose Field Settings
Click Number, and select the date format that you want.
Click OK, click OK
 

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

date 2
Pivot Table Date Format 2
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Pivot Table date format 1
Convert mm-dd-yy to mmm so pivot table reads mmm not mm-dd-yy 1
Split date from date time cells dd/mm/yyyy hh:mm. New cell dd/mm/y 2
Changing date to eliminate day in format mm/dd/yyyy 1
VLOOKUP Dates in a Pivot Table 1

Top