Let us say you have one sales column that you formatted as a number with the commas, then you add a new sales column again, expecting the same numerical formatting would apply… Then you get this:
What happened? Why did your formatting not take effect on the second sales column? I have the perfect workaround for adding predetermined number formatting in Pivot Table. Read on below!
Exercise Workbook:
Here is our current Pivot Table setup:
STEP 1: Let us select the entire Pivot Table. Go to PivotTable Analyze > Actions > Select > Entire PivotTable
STEP 2: Now to select the sales numbers column, go to PivotTable Analyze > Actions > Select > Values
STEP 3: Let us apply our number formatting! Open the Format Cells dialog by pressing CTRL + 1
Select Number and tick the Use 1000 Separator (,)
Click OK
STEP 4: The number formatting is applied on our first Sales column. Now drag SALES to Values
The formatting is also applied to our second Sales column!