Formatting in Word Mail Merge Field

[Marlin]

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

 

[Debbie]

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!

 

[Doug Robbins - Word MVP]

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

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

 

[Doug Robbins - Word MVP]

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

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