scientific notation in pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Right-click on a cell in the field, and choose Field settings
Click the Number button, and set your number formatting
Click OK twice.
 
Back
Top