how to format percetanges from an Excel merge

[CourtneyS]

I was able to correctly format my currency fields in a merge document, but
not percentages. I looked on the resource given in a former post,
www.gmayor.com but when I applied the formatting given, nothing is happening.
When I push Alt F9 I only get «0.00%» even though there is a number in the
field it's supposed to be pulling from in the excel document. I have checked
to ensure the field names match exactly. Can anyone give me an idea what I
might be doing wrong?

Thanks so much

 

[Doug Robbins - Word MVP]

You may need to use Alt+F9 a second time to get the { MERGEFIELD fieldname }
to display. If you cannot get it to display by that method, try deleting
the field and inserting it again from the list of merge fields or insert it
manually by using Ctrl+F9 to insert the field delimiters { } and then
manually type the field code inside of them.

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

 

[Graham Mayor]

If you get «0.00%» you have put the switch and calculation in the wrong
place. Recheck the original instructions matches what you have done.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[CourtneyS]

Firstly, when I go to the website being referenced, it tells me to put in the
following in the field for percentages. (FundMonthly is my merge field name).

{= FundMonthly \# "##%"}

When I put this in, it gives me syntax error.

In the rest of my merge, which is working correctly, the word MERGEFIELD
appears within the paranthesis and I did not use = in any of my field
switches, which looks like the format being given on many field switches on
the website listed above. When I try a variation on the above, for example,

{MERGEFIELD FundMonthly \# "##%"} still there is an error. I also found in
my research somewhere a formula that had a *100 in it.

Basically, what is the correct field switch syntax? My merge field name is
FundMonthly.

Thanks.

 

[Doug Robbins - Word MVP]

Take another look at Graham's website. It does NOT tell you to use {=
FundMonthly \# "##%"}

The example on the site is

{ = { MERGEFIELD Amount } * 100 \# "0%" }

If you want the result displayed to two decimal places, then use

{ = { MERGEFIELD FundMonthly } * 100 \# "0.00%" }

Finally, you must use Ctrl+F9 to insert each pair of field delimiters { }

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