Thanks for your help ScottA, some very useful comments from you.

In further research it turns out formatting in Excel can be preserved in Word by connecting using DDE, which is a whole lot less hastle! A couple of clicks to specify DDE in Word and the rounding problem is not a problem anymore.

More than one way to skin a cat as usual. Once again, thank you for your comments.