Pivot Table in Excel 2007

O

OldManEd

I have a column that has been formatted as an integer, no decimal. When I
create a pivot table this column shows up as currency format. Is there
something I should do BEFORE starting to create a pivot table??
OMEd
 
S

ShaneDevenshire

Just format the Pivot Table.

Put your cursor in the pivot table field and click the Field Settings button
on the toolbar. Click the Format button...
 
O

OldManEd

That's a nuisance. Are you confirming there's a bug? Why does Excel change a
perfectly good format?
Omen
 
S

ShaneDevenshire

As to this being a bug, I can't say. I don't know what microsoft's thoughts
were on this topic when they programmed it the way they did. Certainly one
could make a case for having this feature work differently. I not at home
right now so I can't test 2007 to see if it's changed.
 

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

Pivot Table in Excel 2007????? 4
Pivot using 250,000 rows of data in Excel? 1
Access #Error & Excel Pivot 0
Excel 2007 Pivot Tables 1
Create set based on column items feature in Pivot Tables 2010 1
Excel 2000 Pivot table in Excel 2007 5
Excel VBA For excel 0
Pivot Table Question 2

Top