ExcelBanter - scientific notation in pivot table

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - scientific notation in pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/133912-scientific-notation-pivot-table.html)

scientific notation in pivot table

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.

scientific notation in pivot table

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