Problems with data from Excel

[Marion]

I am doing a mail merge using Word XP where my data comes from Excel.
My first problem is numbers, in Excel I have say the number 2.11 but when it appears in Word it is 2.1099999999999
My second problem are dates, in Excel a date might appear 06/04/04 ie 6th April but in word it appears 04/06/0

Please help!

 

[Doug Robbins - Word MVP]

Hi Marion,

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

and the "Dates: day/month reversed" item under the "Connection methods"
topic of the "Mail merge in Word 2002" section of fellow MVP Cindy
Meister's website at:

http://homepage.swissonline.ch/cindymeister/MergFram.htm


--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP