View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Mark
 
Posts: n/a
Default Numeric rounding problems in mail merge with excel data source.

Hi,

Apologies if this has been posted before, I found nothing about this problem
in the FAQ or Google.

After upgrading from Office 2000 to 2003 a word mail merge, that uses an
excel spreadsheet as a data source, will corrupt any numeric decimal placing
data it is supposed to display. Any values in the spreadsheet that happen
to be a whole number are incorrectly rounded when displayed in the word
'Mail Merge Recipients' window.

E.G.: the spreadsheet correctly rounds the value 6.858 to 6.86, but mail
merge displays it as 6.857999999999997

The spreadsheet and word document were both designed (and still work) in
Word and Excel 2000, but not 2003.

Any ideas?

Thanks

Mark