http://www.gmayor.com/mail_merge_lab...th_word_xp.htm covers the
essential differences between 2000 & 2002 and shows how to make the latter
more like the former.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org




Wim Willemse wrote:
"Peter Jamieson" schreef in bericht
...
Word used to get data from Excel using DDE by default, and numeric
information would come across more or less as it looked in the
spreadsheet. Word 2002 and later use OLEDB by default, and that gets
the underlying data, which does not know how you were displaying
your numbers in Excel. You can either
a. use the old method (Check Word Tools|Options|General|"Confirm
conversion at open", go through the pr ocess of connecting to Excel
again, and choose the DDE option when offered or
b. use numeric format switches (see Word Help for more info), e.g.
use Alt-F9 to display the field codes in Word and change

{ MERGEFIELD mynumber }

to

{ MERGEFIELD mynumber \#"0.00" }

Peter Jamieson

Thank you very much Peter; this explained and solved the problem.
In the office we indeed use word 2002; at home word 2000

Regards Wim