Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formating within pivot table
Howdie, I have created a pivot table that refers to several columns of data. Simple question, but difficult to explain... Several of the columns are percentages (and the cols are for example entitled xxx %efg or yyy % abcd etc) When I use the PivotTable Field list to drag the item into the body of my table, excel defaults the item to a COUNT and NUMBER FORMAT GENERAL. I want it to default to SUM and number format to be PERCENTAGE with one decimal place I can do it manually each time, but as different users are going to be extracting their own data to display I would like to automate the process - IS there VB that can be written that automatically formats all fields with the % sign in them (within the currently displayed pivot table) to the predefined charachteristics (ie SUM and PERCENTAGE) Any other ideas also welcomed! :) Thanks and regards D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel pivot table formating | New Users to Excel | |||
Pivot Table formating | Excel Worksheet Functions | |||
Pivot table formating | Excel Discussion (Misc queries) | |||
need help with pivot table formating | Excel Discussion (Misc queries) | |||
pivot table formating | Excel Discussion (Misc queries) |