Dec 13 2022 10:38 PM
After creating a pivot table, when I double click on the data and a new tab is created, how do I have that data formatted already to show a percentage. My original data is in percents, and my pivot table field settings have percents already formatted on the pivot table too.
I just need the results of double clicking the values to be formatted the same once the new tab is opened.
Dec 14 2022 03:14 AM
As far as I know there's no way to get what you expect, even with a Custom Table Style as the latter only allows formatting Font, Border and Filling color:
Dec 14 2022 01:20 PM