Formatting Pivot Tables
When formatting a Pivot Table is best to right click the values section of the report and choose Number Format.
This will format the whole report, not just the selected range. Avoid using the Format Cells option as it only applies to the range selected.
Please note: I reserve the right to delete comments that are offensive or off-topic.