If you want to reapply your number format when data is pivoted or refreshed, select the data field in the PivotTable, choose ...