| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table formatting numbers
How can I format a column (which isn't a total/summary field) to two decimal
places? Hitting refresh changes it back to the default -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table formatting numbers
To change the format of the data items inside a pivot table (not row, field
or column) double click the upper left corner where the data item tag is located, then click on "Number..." then select the number stile that may fit your needs. "Jock" wrote in message ... How can I format a column (which isn't a total/summary field) to two decimal places? Hitting refresh changes it back to the default -- Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Pivot Table formatting numbers
Hmmm. The 'number' option only appears on totals/summary fields, not on data
fields. -- Traa Dy Liooar Jock "Leo Rod" wrote: To change the format of the data items inside a pivot table (not row, field or column) double click the upper left corner where the data item tag is located, then click on "Number..." then select the number stile that may fit your needs. "Jock" wrote in message ... How can I format a column (which isn't a total/summary field) to two decimal places? Hitting refresh changes it back to the default -- Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Formatting | Charts and Charting in Excel | |||
| pivot table formatting | Excel Discussion (Misc queries) | |||
| Pivot Table Formatting | Excel Discussion (Misc queries) | |||
| Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
| Pivot Table Formatting | Excel Discussion (Misc queries) | |||
Linear Mode
