Studies show that good grammar leads to more promotions and higher salaries. Write with Grammarly

Formatting Values for Pivot Tables in Excel

In this post, you will how to format values for pivot tables in Microsoft Excel.

Formatting Values for Pivot Tables in Excel

When you place values into your Pivot Table, they won’t always be formatted how you want. Excel offers you a feature to format your values in the pivot table.

Let’s see it with an example.

Look at the ex

Formatting Values for Pivot Tables in Excel
  • Insert a pivot table for the data.
Formatting Values for Pivot Tables in Excel
  • Now, to format the values, Select the range of values that you need to format and right-click.
Formatting Values for Pivot Tables in Excel
  • Click on value field settings.
Formatting Values for Pivot Tables in Excel
  • The value field settings dialog box pops up. Click on the Number format on the bottom left corner.
Formatting Values for Pivot Tables in Excel
  • In the format cell menu, under the number section choose the currency option.
Formatting Values for Pivot Tables in Excel
  • You can add decimal places to the value and you can also select the currency symbol.

Or

  • Click the field drop-down menu in the field pane.
Formatting Values for Pivot Tables in Excel
  • Click Value field settings
  • The value field settings dialog box pops up. Click on the Number format on the bottom left corner.
  • In the Format cells dialog box, you can choose your formatting option.

Or

  • Double click on the value field name.
  • The value field settings dialog box opens and you can follow the same procedure to format your values.