Merging Numeric data from Excel

[JulianB]

Within the Excel data, there are a number of fields which are numeric,
some calculated by formulas.

When I merge those fields into Word, the numeric value is the 'Text'
value of the field within Excel.

This means that numeric values can appear as a whole number or as a
partial number rounded to infinity.

What I desperately want is the result to be rounded (2), but cannot
find a resolution to this.

Can anyone suggest a solution?

 

[Doug Robbins - Word MVP]

Hi Julian,

In the mailmerge main document, use Alt+9 to toggle on the field codes and
inside the closing } insert the following numeric picture switch

\# "#.00"

Use Alt+F9 again to toggle off the field codes and then execute the merge.

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
*If you're seeing this through Irubin's crappy web site, you should know
that he does not have my permission to include this message on his website.
I own the copyright, and I grant a license to Microsoft, Google and the
usenet community. I deny Irubin the right to repost my message on his

 

[JulianB]

Doug,

Perfect! Thank you very much.

Julian