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.

SusanJane sjl wrote:
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.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html