Problem while mailmerging with an Excel datasource

  • Thread starter Thread starter PS
  • Start date Start date
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
 
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
 
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
 
Back
Top