I have a pivot table that uses data from a list that is formatted as a number
with two decimal places. I formatted the field in the pivot table with the
same format. However, when I do a refresh, it will lose the formatting and
apply about 10 decimal places instead. Any ideas?

On the PivotTable options do you have Preserve Formatting checked?

"Douglas O''Neill" wrote:

I have a pivot table that uses data from a list that is formatted as a number
with two decimal places. I formatted the field in the pivot table with the
same format. However, when I do a refresh, it will lose the formatting and
apply about 10 decimal places instead. Any ideas?

Right-click on a cell that you want to format, and choose Field Settings
Click the Number button
Set the formatting, then click OK, click OK

Douglas O''Neill wrote:
I have a pivot table that uses data from a list that is formatted as a number
with two decimal places. I formatted the field in the pivot table with the
same format. However, when I do a refresh, it will lose the formatting and
apply about 10 decimal places instead. Any ideas?


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