Hi
I have both a regular chart graphed from a pivot table and a pivot chart that use a Power Pivot table as their data source. For a number field that is in the pivot table, I cannot get this number to be formatted as a number with a thousands separator (comma). The data in the pivot table is displayed with the comma/thousands separator and I am formatting the cell in the pivot table as a number with a comma/thousand separator. However, the number is just displayed as is, without the comma.

Does anyone know of a way to display the comma?

Paul