Pivot table formatting

  • Thread starter Thread starter Vicky
  • Start date Start date
V

Vicky

When I create a pivot table the numberic data is rounded, My original data
not. Why does this happen, how can I fix?
 
Hi Vicky

Double click on the data field>Number>set the format you want
 
You must log in or register to reply here.

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 - Changes 5
date filter in a pivot table 1
Pivot table filter list - listing irrelevant subcategorys 1
Pivot Table date format 1
New To Pivot Tables 4
Adding to an existing Pivot Table 7
Pivot tables - memory issues - please help 2
formatting date for pivot table 2

Back
Top