Pivot Table Number Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to set the number format default for pivot tables (or
excel) to something other than what it is? For example, I want the default
to be " ," and 0 digits. Alternatively, can you set the format for a group
of fields vs. setting 1 at a time. Thank you.
 
Hi Sarah

You cannot set a default number format in PT's in any version of Excel.
You cannot set it for a group of fields at a time, it has to be field by
field.

If the PT is on a separate sheet, you could select the relevant columns
of your table by holding Control as you click them, then right click and
set the number format for them all in one go.
 
You must log in or register to reply here.

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

Pivot Table Defaults 1
Peculiar default cell format 1
HDMI is a terrible format and I wish it never existed 2
Pivot table column help 2
Pivot table help for excel 2003 2
Pivot Table Format Default 1
Pivot table format question 3
Lose formatting on pivot tables 3

Back
Top