setting default value field settings


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?
 
Ad

Advertisements

T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top