Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Number Format
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Number Format
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. -- Regards Roger Govier "Sarah" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Question: Show percentages and standard number format | Excel Discussion (Misc queries) | |||
Pivot Table Format | Excel Discussion (Misc queries) | |||
Help on Pivot Table Format | Excel Worksheet Functions | |||
how to format in pivot table | Excel Discussion (Misc queries) | |||
Format a Pivot Table | Excel Discussion (Misc queries) |