Hi Charles,

Thanks for looking at this for me. I am guessing that it may not be possible as you suggest and the frustrating thing for me is that any further than simple macros I am stumped, I am not a programmer.

However, can I just confirm with you the fact that I do not want the pasted material to update with the rest of the document, I would be very happy with being able to paste the numbers and text as plain text and never have it interact again, I just need to to reflect its original number.

Thanks again, all the best, Barney

You can do this, not retaining any formatting, using the paste option for plain text. It will keep the original numbers.


It will not be a hyperlink to the original. It will not update.

Hello Charles, this is not the case if you copy and paste one at a time, if you right click the appropriate style, select all and paste or use the Ctrl button to selectively highlight and then copy and paste the numbers re format, even when using paste text only.

Cheers, Barney