Field Formatting in Pivot Tables

C

cvsbean

Ok I know how to preserve formatting so when I update or pivot Pivot Tables
the number format of a field remains the same.

My problem is this. When i drag a value field out of the pivot table and
then back in - my number formatting is lost. Is there anyway to fix this!!???
 
D

Debra Dalgleish

No, the number formatting will default to General when you add the field
back to the Value area. There's no setting you can change to make this
behave differently.
 

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

Excel 2003 Pivot Formatting 2
Excel VBA For excel 0
Pivot Table formatting 2
grouping multiple tables Excel 2007 3
Pivot Table Formatting 4
Excel Pivot Tables 1
preserve formatting option in pivot table 1
Single Filter to change all Pivot Tables in a Workbook 8

Top