Forum Discussion
Default Value Field Settings
Is it possible to adjust the default settings for "Value Field Settings". I would like to have my pivot table default to "Accounting" format with "0" decimal places. Thank you
Hi Khalid19635
You can create custom format that include all your requirement, then apply that format to the cells
from the format cells choose custom then write this $#,## in the type then OK
Jihad Al-Jarady Thanks for the reply. Is it possible to make this a permanent default so that whenever I create my pivot its already in this "Field Settings" format?
Hi Khalid19635
This feature is not available yet. Because when we load data to Pivot table, it defaults to General type. So we need to manually change the formatting of the number in the Pivot table.