Andreas Säger wrote
The number formats are taken from the source cells. Anything else can be
set in the styles that are generated for the pivot tables.
Hi Andreas, thanks for your reply.
Unfortunately the formatting of the cells in question does not carry forward
to the pivot table
The cells in pivot tables do not retain their format when the pivot table is
refreshed. I am using date and time formats in the pivot table (heading and
main part) and each time the table is refreshed, I have to select the
relevant cells and reformat them to the correct format.
Am I missing some