scientific notation in pivot table

S

SusanJane sjl

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