setting default value field settings

  • Thread starter Thread starter hbecker
  • Start date Start date
H

hbecker

I do a lot of work with pivot tables, and in almost all cases I need the
value field to be numeric using a comma separator with 0 decimal places. How
do I set my Excel preferences for defaults like this?
 
I do not believe that there is a way to do this under current functionality.

You have to use Format Cells the same way as you use it elsewhere.

Please hit Yes if my comments have helped.
 
Back
Top