pivot tables change number format when switching pages

A

april

i have set up a pivot table with the companies on the page tab. when it is
set to "All", i formatted the cells with the number format, 2 decimals, and a
comma. when i switch to company 1, the formatting disappears. if i format
it with the comma, then switch to another company, then switch the format
disappears. why is this? and is there a way to prevent it?

thanks in advance.
 
A

april

sorry about that. i have looked more closely and this is not an issue.
please escuse me.
 

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

2007: Number format <> Number format 1
Pivot Table Formatting 4
Field Formatting in Pivot Tables 1
Excel 2003 Pivot Formatting 2
Modify Toolbar Button Styles 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
scientific notation in pivot table 1
Pivot Table Change to US Date Format - Why? 2

Top