PivotPal Guide - Automatically Format Numbers in the Values Area of Excel Pivot Table

PivotPal Guide - Automatically Format Numbers in the Values Area of Excel Pivot Table

 

 

so pivot pals automatic formatting is probably one of the best features of pivot pal because it will save you a lot of time basically what happens is when you add a field to the values area of your pivot table pivot pal automatically detects the source formatting of that field in the source data sheet and then we'll apply that formatting to the to the pivot table itself to the field of the pivot table so let me show you how that works 

Related Topics:

• How to Write Macros for SUBTOTAL Formulas - Clip from Live Q and A Meeting
• 2 Ways to Reverse the Number Sign Positive Negative in Excel 
• Convert Text to Numbers With Negative Sign at the End
• Filter for Duplicates with Conditional Formatting