Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table vicious cycle
Hello When ever I refresh my pivot table the columns that have % become
numbers example I have a 8% when I refresh the table it becomes 0.08 . so I reformat the columns. Is there a way that the % stays a percent? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table vicious cycle
when you reformat , are you doing the format within the Pivot table? Right
click on one of the % number, format , and it should bring up a box that says "PivotTable Field" Then click number and format as %. It should retain that even after refresh. "Wanna Learn" wrote: Hello When ever I refresh my pivot table the columns that have % become numbers example I have a 8% when I refresh the table it becomes 0.08 . so I reformat the columns. Is there a way that the % stays a percent? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table vicious cycle
Thank you Don
I have excel 2002 When I right click on the pivot table I do not have a box that reads "Pivot table Field" If I right click (within the pivot table) I do have the option "format cells". I formatted the cells as percentage Now when I refresh the pivot table some of the numbers are correct example they read 10% while other go show 0.1 thanks in advance "Don" wrote: when you reformat , are you doing the format within the Pivot table? Right click on one of the % number, format , and it should bring up a box that says "PivotTable Field" Then click number and format as %. It should retain that even after refresh. "Wanna Learn" wrote: Hello When ever I refresh my pivot table the columns that have % become numbers example I have a 8% when I refresh the table it becomes 0.08 . so I reformat the columns. Is there a way that the % stays a percent? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
How do I keep result from 1 iteration cycle to use in next cycle? | Excel Discussion (Misc queries) | |||
Vicious circle (Opening Excel attachment) | Excel Discussion (Misc queries) |