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
Access stripping decimal places in query 1
Is there a settings startup file for Excel? 5
How do I set the default format in a workbook to numeric? 1
Pivot Table default Value Field Settings 1
Excel 2002 : How to set thousand separator at tool bar ? 2
Decimal dot to Decimal Comma 3

Top