scientific notation in pivot table

G

Guest

I have a very large number in a pivot table . I format the column that
contains the number as numeric with 0 decimals. The source of the pivot
table also defines that field as numeric. The number looks fine:
999999009952

Then I save the pivot table. When I open it back up the number reads:
9.99999E+11 and the column is formatted as general.

It's driving me crazy - please help.
 
D

Debra Dalgleish

Right-click on a cell in the field, and choose Field settings
Click the Number button, and set your number formatting
Click OK twice.
 

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

Using text values in Pivot Tables 5
Unable to Group in Pivot Table 1
Pivot table column limits 2
date filter in a pivot table 1
Pivot Table - NUMBER FORMAT option does not appear in field settin 3
Date/Time issue with Pivot Table 3
Excel turning percentages into scientific notation 2
Surpressing rows and columns with zero values in a pivot table 1

Top