Merge numbers from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frame - 24 Jan 2004 15:31 GMT

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.

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Jan 2004 00:26 GMT

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"

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 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
[quoted text clipped - 5 lines]
>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.

Reply to this Message

Amy O' - 08 Mar 2004 15:41 GMT

Is it possible to format this number into a percentage in the merge document?

Thanks!

Reply to this Message

Rocky - 25 Jan 2004 17:06 GMT

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

Reply to this Message

Doug Robbins - Word MVP - DELETE UPPERCASE CHARACTERS FROM EMAIL ADDRESS - 25 Jan 2004 23:27 GMT

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

Signature

> Did you get a solution to your problem?
>
[quoted text clipped - 3 lines]
>
> Rocky

Reply to this Message