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

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

"CourtneyS" wrote in message
...
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

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



CourtneyS wrote:
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

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.



"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



CourtneyS wrote:
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

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

"CourtneyS" wrote in message
...
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.



"Graham Mayor" wrote:

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



CourtneyS wrote:
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