Pivot Table formatting numbers

G

Guest

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
 
L

Leo Rod

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.
 
G

Guest

Hmmm. The 'number' option only appears on totals/summary fields, not on data
fields.
--
Traa Dy Liooar

Jock


Leo Rod said:
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.
Click to expand...
 

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

Average of Subtotals in Pivot Table 0
Peculiar default cell format 1
Triming a number 1
Access stripping decimal places in query 1
Pivot table column help 2
Pivot Table Defaults 1
pivot table loosing decimals (vba) 1
Pivot table format question 3

Top