Formatting in Word Mail Merge Field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marlin - 11 May 2004 22:42 GMT

Good day. I have a problem with Word that is driving me
nuts. Has to be an easy fix. First, some background:

Using Excel file and data file for word merge.

Merge field is number field, formatted in Excel as number
field to two decimal places. Formats properly in Excel.
When merged to word, number that merges in changes to a
value carried to the - 10 to the 12th place. For
instance, 1.28 in the excel file merges in as
1.270000000009 or worse gibberish.

Can anyone help?

Thanks. Marlin

Reply to this Message

Debbie - 12 May 2004 00:12 GMT

Oh man, I am having the exact same problem as we speak.
Please someone answer this one before I need a straight-
jacket. Many thanks!

>-----Original Message-----
>Good day. I have a problem with Word that is driving me
[quoted text clipped - 13 lines]
>Thanks. Marlin
>.

Reply to this Message

Doug Robbins - Word MVP - 12 May 2004 05:15 GMT

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

http://www.gmayor.com/formatting_word_fields.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

> Oh man, I am having the exact same problem as we speak.
> Please someone answer this one before I need a straight-
[quoted text clipped - 17 lines]
> >Thanks. Marlin
> >.

Reply to this Message

Doug Robbins - Word MVP - 12 May 2004 05:15 GMT

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

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

Signature

> Good day. I have a problem with Word that is driving me
> nuts. Has to be an easy fix. First, some background:
[quoted text clipped - 11 lines]
>
> Thanks. Marlin

Reply to this Message