Is there a way to remove a formatted column(s)(metric) from a pivot table, then add that column(s) back and retain the original formatting? I need the formatted values to hold, as well as the column name. Everytime I remove a column and add it back, the column name goes back to "sum of "columnname" and the values reformat as well. Please Help!!! Is there a way to make the formatting stick when removing and re-adding columns to a pivot?
Thanks in advance, deno95
Thanks in advance, deno95