View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
John Richmond, Watford UK
 
Posts: n/a
Default ExcelWord Mail merge transfers 16 digits when Excel shows only 3

In producing reports by mailmerge from Excel into Word, an Excel cell holding
a calculated value formatted to display as 3.45 will be shown as
3.449993782999200000. Even cells carefully formatted to integers e.g 3 will
often transfer to 3.0000000000000001. Percentages such as 78% get
transferred as 0.798745300322220 Only if the values have been typed in will
the mail merge show the correct number.

This did not happen with previous versions of Word and Excel, where the
number was transferred as formatted in Excel. Is there any way of putting
this right?

Versions in use are Word 2002 SP3 and Excel 2002 SP3