HomeMicrosoft OfficeExcelFormatting Values for Pivot Tables in Excel

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.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021