

MATCH Function
Roman Kondratiuk
Fields imported into a Power Pivot Data Model appear with formatting that has been applied in the source location where that data was created.
When you format data in a Data Model, the formatting will be replicated in any PivotTable that uses the formatted data within that workbook.