---
title: Batch Value Field Settings
description: "  Copy and paste this VBA Code for Averages with NO decimal places:   Public Sub SetDataFieldsToAverage() 'Update 20141127 Dim xPF As PivotField Dim WorkRng As Range Set WorkRng = Application.Selectio"
---

[Skip to content](https://processes.premiercrop.com/knowledge/batch-field-value#main-content)

[Customer portal](https://processes.premiercrop.com/tickets-view?hsLang=en)

![PCS-Black-icon-1.png\]](https://processes.premiercrop.com/hs-fs/hubfs/PCS-Black-icon-1.png?width=35&height=40&name=PCS-Black-icon-1.png)

- [Tickets](https://processes.premiercrop.com/tickets-view)
- [Sign out](https://processes.premiercrop.com/_hcms/mem/logout)

Open main navigation

Close main navigation

- [Tickets](https://processes.premiercrop.com/tickets-view)
- [Sign out](https://processes.premiercrop.com/_hcms/mem/logout)
- [Customer portal](https://processes.premiercrop.com/tickets-view)
- [Go to premiercrop.com](https://services.premiercrop.com/)

[Go to premiercrop.com](https://services.premiercrop.com/)

 What do you need help with today?

- There are no suggestions because the search field is empty.

1. [Premier Knowledge Base](https://processes.premiercrop.com/knowledge?hsLang=en)
2. [Premier Crop Systems Software Training](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en)
3. [Tips and Tricks](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#tips-and-tricks)

# Batch Value Field Settings

<iframe data-hsv-src="https://play.hubspotvideo.com/v/4362973/id/145612279619" referrerpolicy="origin" sandbox="allow-forms allow-scripts allow-same-origin allow-popups" allow="autoplay; fullscreen;" style="position: absolute !important; width: 100% !important; height: 100% !important; left: 0; top: 0; border: 0 none; pointer-events: initial" title="HubSpot Video" loading="lazy" data-hsv-id="145612279619" data-hsv-style="" data-hsv-width="688" data-hsv-height="374" data-hsv-autoplay="false" data-hsv-loop="false" data-hsv-muted="false" data-hsv-hidden-controls="false" data-hsv-full-width="false"></iframe>

 

**Copy and paste this VBA Code for Averages with NO decimal places:**

 

Public Sub SetDataFieldsToAverage()

'Update 20141127

Dim xPF As PivotField

Dim WorkRng As Range

Set WorkRng = Application.Selection

With WorkRng.PivotTable

   .ManualUpdate = True

   For Each xPF In .DataFields

     With xPF

         .Function = xlAverage

         .NumberFormat = "#,##0"

     End With

   Next

   .ManualUpdate = False

End With

End Sub

 

**Copy and paste this VBA Code for Average Costs with standard currency:**

Public Sub SetDataFieldsToAverage()

'Update 20141127

Dim xPF As PivotField

Dim WorkRng As Range

Set WorkRng = Application.Selection

With WorkRng.PivotTable

   .ManualUpdate = True

   For Each xPF In .DataFields

     With xPF

         .Function = xlAverage

         .NumberFormat = "$#,##0.00"

     End With

   Next

   .ManualUpdate = False

End With

End Sub

- [Getting Started with Premier Crop](https://processes.premiercrop.com/knowledge/getting-started-with-premier-crop?hsLang=en#main-content)

    - [Advisor Excel-erator](https://processes.premiercrop.com/knowledge/getting-started-with-premier-crop?hsLang=en#advisor-excel-erator)
- [Premier Crop Systems Software Training](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#main-content)

    - [Field Management](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#field-management)
    - [Nutrients](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#nutrients)
    - [Mgmt Zones](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#mgmt-zones)
    - [Seed](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#seed)
    - [Crop Protection](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#crop-protection)
    - [Operations](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#operations)
    - [Premier Intelligence](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#premier-intelligence)
    - [Data Exchange](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#data-exchange)
    - [Reports](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#reports)
    - [Analytics](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#analytics)
    - [Dashboards](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#dashboards)
    - [Webinars](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#webinars)
    - [System Information](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#system-information)
    - [Tips and Tricks](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#tips-and-tricks)
    - [Unpublished Videos](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#unpublished-videos)
    - [Release Note](https://processes.premiercrop.com/knowledge/premier-crop-systems-software-training?hsLang=en#release-note)
- [Analyst Studio](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#main-content)

    - [Getting Started](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#getting-started)
    - [Visualizations](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#visualizations)
    - [Filters](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#filters)
    - [Calculated Fields](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#calculated-fields)
    - [Exporting](https://processes.premiercrop.com/knowledge/analyst-studio?hsLang=en#exporting)
- [Hardware & Software](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#main-content)

    - [Ag Leader](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#ag-leader)
    - [Case IH](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#case-ih)
    - [John Deere](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#john-deere)
    - [Kinze](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#kinze)
    - [Precision Planting](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#precision-planting)
    - [Raven](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#raven)
    - [SMS](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#sms)
    - [Trimble](https://processes.premiercrop.com/knowledge/hardware-software?hsLang=en#trimble)
- [Sales](https://processes.premiercrop.com/knowledge/sales?hsLang=en#main-content)

    - [Sales Resources](https://processes.premiercrop.com/knowledge/sales?hsLang=en#sales-resources)
    - [Partner](https://processes.premiercrop.com/knowledge/sales?hsLang=en#partner)

[![Chill listening crop-3](https://processes.premiercrop.com/hs-fs/hubfs/PCS-Black-icon.png?width=21&height=24&name=PCS-Black-icon.png "Chill listening crop-3")](https://4362973.hs-sites.com/knowledge?hsLang=en)

Premier Processes

<https://www.facebook.com/premiercropsystems/> <https://twitter.com/premiercrop> <https://www.linkedin.com/company/18787376/admin/>

Copyright © 2026, Powered by Premier Crop Systems

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://4362973.fs1.hubspotusercontent-na1.net/hubfs/4362973/BatchValueFieldSettings-REAL.mp4",
  "dateModified" : "2023-11-15T13:00:54.987Z",
  "duration" : "PT1M16S",
  "height" : 1040,
  "name" : "BatchValueFieldSettings-REAL",
  "thumbnailUrl" : "https://4362973.fs1.hubspotusercontent-na1.net/hubfs/4362973/BatchValueFieldSettings-REAL.mp4/medium.jpg",
  "uploadDate" : "2023-11-15T13:00:47.236Z",
  "width" : 1912
}
```