Problem while mailmerging with an Excel datasource

[PS]

Hi everybody,

is there a known issue when trying to mailmerge in WORD with an Excel datasource when the merged EXCEL columns contain formulas.
Everything works fine, except that WORD doesn't respect the format settings defined in Excel.
For example, a value (63,24) in a column defined in EXCEL as NUMBER - decimal places 2 shows up in the mailmerged WORD document as 63,236249999999998

We work with WORD 2002 SP-3 and EXCEL 2002 SP-3.

Thanks in advance for any help.

Best regards.
Patrick

 

[Arvi Laanemets]

Hi

Replace your formula(s) in excel with
=ROUND(YourFormula,2)


--
Arvi Laanemets
(When sending e-mail, use address arvil<At>tarkon.ee)


Hi everybody,

is there a known issue when trying to mailmerge in WORD with an Excel
datasource when the merged EXCEL columns contain formulas.
Everything works fine, except that WORD doesn't respect the format settings
defined in Excel.
For example, a value (63,24) in a column defined in EXCEL as NUMBER -
decimal places 2 shows up in the mailmerged WORD document as
63,236249999999998

We work with WORD 2002 SP-3 and EXCEL 2002 SP-3.

Thanks in advance for any help.

Best regards.
Patrick

 

[Paul B]

Patrick, you may also want to copy the worksheet and change everything to text to avoid any problems, see here for some tips on mail merge
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

Hi everybody,

is there a known issue when trying to mailmerge in WORD with an Excel datasource when the merged EXCEL columns contain formulas.
Everything works fine, except that WORD doesn't respect the format settings defined in Excel.
For example, a value (63,24) in a column defined in EXCEL as NUMBER - decimal places 2 shows up in the mailmerged WORD document as 63,236249999999998

We work with WORD 2002 SP-3 and EXCEL 2002 SP-3.

Thanks in advance for any help.

Best regards.
Patrick

 

[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