# Excel Pivot Table field settings

**URL:** <https://boards.straightdope.com/t/excel-pivot-table-field-settings/364335>\
**Category:** Factual Questions\
**Created:** [July 13, 2006, 3:53pm UTC](https://boards.straightdope.com/t/excel-pivot-table-field-settings/364335 "2006-07-13T15:53:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![taxi78cab](https://avatars.discourse-cdn.com/v4/letter/t/e47c2d/32.png) [@taxi78cab](https://boards.straightdope.com/u/taxi78cab)\
**Post date:** [July 13, 2006, 3:53pm UTC](https://boards.straightdope.com/t/excel-pivot-table-field-settings/364335/1 "2006-07-13T15:53:19Z")

</div>

Is there any way to keep the field settings for a particular field when moving it in and out of a pivot table? Currently, every time I move a field back into the pivot table, I have to reset it to, say, a currency format because it always defaults back to a general format.

Also, I have some fields that I want to be Sums and some that should be Averages. Usually it gets the Sums right, but the field that I want it to average, it always gives me a Count. It’s very frustrating having to reformat these fields every time I move them into the table. Isn’t there any way to tell it that Revenue should always be a Summed field in a Currency format, but Customers should always be a Number format?