Excel data source for Word mail merge

[Bernie Simmonds]

When using an Excel spreadsheet as the data source for mailmerge in
Office 2003 the merged numbers in the Word document are often displayed
with many decimal places. eg. if the number in excel is 2.8 it merges as
2.79999999 in Word.

I've tried rounding in Excel but it makes no difference.

Using the same spreadsheet with Office 2000 it works fine.

How do I get Excel / Office 2003 to integrate and present the correct
numbers in Word merges?

Bernie

 

[Debra Dalgleish]

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

 

[JE McGimpsey]

The right way to do this is to use a Numeric Picture switch in Word's
merge field. See "Numeric Picture (\#) field switch" in Word Help).

For example:
{MERGEFIELD Field1 \# "0.000" }

http://homepage.swissonline.ch/cindymeister/mergfaq.htm#NumFormat