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!
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 (,)
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!
Make sure to download our FREE PDF on the 101 Best Excel Tips & Tricks: