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