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.