I've created a document with a number of different pivot tables.
Currently some of the fields are formatted in £ (not all some are formatted in number format)
Is there VBA that can be written to change all the fields formatted as £ on all the pivots into $ with a click of one button?
Currently some of the fields are formatted in £ (not all some are formatted in number format)
Is there VBA that can be written to change all the fields formatted as £ on all the pivots into $ with a click of one button?