hi Paul,

Can you please upload an example workbook with a tiny amount of dummy data (just enough to make a PT work) & all of your recorded code?
This provides some more context for us to help with - and if necessary (ie we can't modify it for the same file) we can provide looping code to create all the formatted values from the PT's into a new file (& delete the original/save with a new name etc).

Rob