View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Leo Rod Leo Rod is offline
external usenet poster
 
Posts: 21
Default 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