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

Similar Threads

value field preferences 1
Want to open worksheet in preformatted style 1
Mail Merge - displaying a conditional number of decimals 5
Finding the proper style field and the numbered paragraph value within the style 0
Is there a settings startup file for Excel? 5
Pivot Table default Value Field Settings 1
How do I set the default format in a workbook to numeric? 1
How can I change the default number of decimal places in Excel? 1

Top