Percentages in word 2007 via merge with excel

[Barry Baker]

I am having trouble with converting the percentages from 14 digits ( or so
)to a simple 54% display ( for example ) I have tried the *100 code but
am having problems, perhaps i'm typing it in wrong, can someone paste me the
code on here please

 

[Doug Robbins - Word MVP]

Add the following formatting switch inside the closing } of the field code
that is displayed when you use Alt+F9 to toggle on its display :

\# ",0.00%"

Delete the .00 if you do not want any decimal points.

For more information on the use of formatting switches, see "Formatting Word
fields with switches" on fellow MVP Graham Mayor's website at :

http://www.gmayor.com/formatting_word_fields.htm




--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[macropod]

Hi Barry,

In Word, add a formula and numeric picture switch to the mergefield. To do this:
.. select your mergefield, which will look something like «Percent»;
.. press Ctrl-F9 to wrap another field around it, thus - { «Percent» };
.. edit the field so that you get {=«Percent»*100 \# 0.00%};
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: the precision of the displayed value is controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'.

 

[Barry Baker]

macropod

You are the BOY. That works perfectly, well done for explaining it simply.
Brilliant.