Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Field Formatting in Pivot Tables
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!!??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Field Formatting in Pivot Tables
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. cvsbean wrote: 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!!??? -- Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value Field Settings for Pivot tables | Excel Worksheet Functions | |||
Pivot tables Percentage of Row Field | Excel Discussion (Misc queries) | |||
Where has my field list gone for my Pivot Tables? | Excel Worksheet Functions | |||
Page field in pivot tables | Excel Discussion (Misc queries) | |||
pivot tables-data field formatting | Excel Discussion (Misc queries) |