Merge numbers from Excel

[Frame]

I am trying to use an Excel document as the source for merging information into Word. In Excel, I have a cell which is "computed" (ie. one cell divided by another). When I pull this information into Work, I am getting 9+ digits to the right of the decimal point. I have tried numerous things in Excel including rounding, truncating, copying the rounded numbers over to a cell using values only and using these cells as my source documents. Even when the cell in Excel is showing me that it has nothing in it but a value of 7.6 (no formulas), it is still pulling into the Work document as 7.555559. I am at my wits end! Thanks in advance for any help.

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

In the mailmerge main document, add the following formatting switch inside
the closing } of the merge field (Press Alt+F9 to toggle the field codes on
and off)

\# "#,##0.00"

--
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

 

[Rocky]

Did you get a solution to your problem

I have been trying to merge currency fields from Excel to Word for the last month without any results. I have tried using field codes as described in books and still no results. Do you have any ideas

Rocky

 

[Doug Robbins - Word MVP - DELETE UPPERCASE CHARACT]

There is an answer. You must expand the thread by clicking on the + sign to
see it. But if you don't know that, you probably won't see this or your own
post for that matter.

See the following page of fellow MVP Graham Mayor's website:

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