how to format percetanges from an Excel merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CourtneyS - 08 Mar 2006 03:35 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 08 Mar 2006 04:56 GMT

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.

Signature

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

>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,
[quoted text clipped - 8 lines]
>
> Thanks so much

Reply to this Message

Graham Mayor - 08 Mar 2006 07:50 GMT

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.

Signature

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

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

> I was able to correctly format my currency fields in a merge
> document, but not percentages. I looked on the resource given in a
[quoted text clipped - 6 lines]
>
> Thanks so much

Reply to this Message

CourtneyS - 08 Mar 2006 17:32 GMT

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.

> 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.
[quoted text clipped - 9 lines]
> >
> > Thanks so much

Reply to this Message

Doug Robbins - Word MVP - 08 Mar 2006 19:59 GMT

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

Signature

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

> Firstly, when I go to the website being referenced, it tells me to put in
> the
[quoted text clipped - 35 lines]
>> >
>> > Thanks so much

Reply to this Message