Date prob with Pivot Table

[jct]

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

[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

jct wrote:
> 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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html