Problem while mailmerging with an Excel datasource

P

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
 
A

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
 
Top