Problems with data from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marion - 06 Apr 2004 21:56 GMT

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!

Reply to this Message

Doug Robbins - Word MVP - 07 Apr 2004 05:15 GMT

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

Signature

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

>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
[quoted text clipped - 3 lines]
>
> Please help!!

Reply to this Message