Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using HTML file as data source for Mail Merge | Mailmerge | |||
word cannot open file as a data or header source bec it is a mail merge main doc | Mailmerge | |||
Unable to open excel data source for word mail merge | Microsoft Word Help | |||
printing a data source from a mail merge document | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge |