Hello

I am summarising data in a pivot table.

I found that some fields that come through onto the pivot do not retain the
currency format from the data.

E.g. 40000 shown instead of 40,000.00

I would like it to retain the format so that I do not have to change the
format each time the pivot table is refreshed

Thank you