I have created a very complex excel data base using excel 2003. The spreadsheet contains a large number of columns and uses formulea to create a description of a package of support which involves personal information of the service user and the value of their support package calculated out into hours of support and both the value of elements of the package and the value of the total cost.
This spreadsheet is then connected to a mail merge document I have created in word 2003. This document forms the basis of a contractual description of the package and all its different elements and their values. As such the document has a set format and uses mail merge fields to transfer specific data and costings relevant to each person's package. As may colleagues have to do about 100 of these contracts and they need to be updated, the information has to be transferred accurately.
My problem is that having set the spreadsheet up to automatically calculate through the value of a person's package, rounding this up or down to two decimal places. When the value that appears in the spreadsheet is transferred over to the word document - the formatting control on the number of decimal places is lost and the figure that had been to two decimal places on the spreadsheet, is displayed in the word document as a figure with nine decimal places.
Can someone please advise me as to how I can stop the mail merge document displaying the transferred data to nine decimal places, and keep it as it appears on the spreadsheet.
Any advice would be most welcome and will stop me from getting lynched by work colleagues, who don't think my "bright idea" is actually very helpful as they still have to edit the documents down from nine decimal places.