Formatting fields in Word (using Excel as Mail Merge Data)

Formatting fields in Word (using Excel as Mail Merge Data) - need.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John - 11 Apr 2005 22:39 GMT

I have a Word document set up as a Mail Merge, using an Excel worksheet as my
data source. I am comparing two fields - current month sales vs. same month
last year, to get a sales ratio. I formatted the result in Excel so that
when the answer is, say "0.354", I get "35.4%". When I bring that "result"
field over into Word, I still get the "0.354". How do I format the
mail-merge field to show percentages (and even better would be to show a "+"
and "-" sign to indicate the appropriate fluctuation)?

Reply to this Message

Peter Jamieson - 12 Apr 2005 12:24 GMT

To do the calculation you need to get 35.4 from 0.354, use e.g.

{ =100*{ MERGEFIELD mypercentagefield } }

Then use a numeric format switch to format the data, e.g.

{ =100*{ MERGEFIELD mypercentagefield } \#"+0.0%" }

where all the {} are inserted using ctrl-F9.

It's probably simpler to specify the maximum number of zeroes after the
decimal point that you use, e.g. if it is two, use
\#"+0.00%", and accept that Word will display trailing zeroes.

Peter Jamieson

>I have a Word document set up as a Mail Merge, using an Excel worksheet as
>my
[quoted text clipped - 7 lines]
> "+"
> and "-" sign to indicate the appropriate fluctuation)?

Reply to this Message

Rate this thread: