Pivot Table not retaining currency format

[creative999]

Hi

I have a pivot table with one column formatted as a 'Number / Currency', and the data worksheet is formatted as 'General'

When the data is refreshed, any new values in the pivot table column don't match the format of the existing values, for example, currency format lost on some values and alignment doesn't match. I have the Preserve Pivot Table format ticked but it hasn't helped the currency column.

Any suggestions?