How do you merge a field as a percentage?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Merge Query - 20 Jun 2006 08:09 GMT

Help - I noticed there was information provided earlier, however I have found
this unhelpful.
When I merge a percentage it is coming across as a decimal, I have tried the
DDE option and this has not worked.

Look forward to your response

Reply to this Message

Peter Jamieson - 20 Jun 2006 08:51 GMT

For whole number percentages you should be able to use a nested field

{ ={ MERGEFIELD mypercentage } * 100 \#0% }

For fractional percentages such as 41.5% you can use, e.g.

{ ={ MERGEFIELD mypercentage } * 100 \#0.0% }

(add as many 0s at the end as you need) or

{ ={ MERGEFIELD mypercentage } * 100 \#0.#% }

(add as many #s at the end as you need)

In all cases, you need to substitute the correct field name instead of
"mypercentage", and the {} are all the special field code braces that you
can insert using ctrl-F9.

(What that won't do is display the perecentage in exactly the same format as
it appears in your data source. For example, if your data source may show
1.00% as 1%, 1.20% as 1.2%, 1.23% as 1.23% etc. whereas
a. the \#0.0% switch would result in 1.0%, 1.2% and 1.2% respectively
b. the \#0.#% switch would result in 1.<space>%, 1.2% and 1.2%
respectively
c. a \#0.00% switch would result in 1.00%, 1.20% and 1.23% respectively
...and so on. I don't have field code that does that and although it may be
fairly easy to do something useful it's probably best avoided unless you
really need it. Maybe macropod has tested code for that?)

Peter Jamieson

> Help - I noticed there was information provided earlier, however I have
> found
[quoted text clipped - 4 lines]
>
> Look forward to your response

Reply to this Message

Merge Query - 21 Jun 2006 00:04 GMT

Peter

Thanks for the advice - I have done this and below is how the merge comes
out like:
{ = {0.00000000000000E-2 * 100\#0.00% }

Regards

> For whole number percentages you should be able to use a nested field
>
[quoted text clipped - 35 lines]
> >
> > Look forward to your response

Reply to this Message

Peter Jamieson - 21 Jun 2006 00:33 GMT

What result do you get when you use { MERGEFIELD mypercentage } on its own?

Peter Jamieson

> Peter
>
[quoted text clipped - 46 lines]
>> >
>> > Look forward to your response

Reply to this Message

Merge Query - 21 Jun 2006 01:43 GMT

Number wanted to display 7.22%

displaying :7.2218607677293434E-2

> What result do you get when you use { MERGEFIELD mypercentage } on its own?
>
[quoted text clipped - 50 lines]
> >> >
> >> > Look forward to your response

Reply to this Message

Doug Robbins - Word MVP - 21 Jun 2006 04:50 GMT

Did you use Ctrl+F9 for each pair of field delimiters?

You need { = { MERGEFIELD mypercentage } * 100 \# "0.00%" }

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

> Number wanted to display 7.22%
>
[quoted text clipped - 64 lines]
>> >> >
>> >> > Look forward to your response

Reply to this Message

Merge Query - 21 Jun 2006 07:10 GMT

Yes I did

> Did you use Ctrl+F9 for each pair of field delimiters?
>
[quoted text clipped - 68 lines]
> >> >> >
> >> >> > Look forward to your response

Reply to this Message

Doug Robbins - Word MVP - 21 Jun 2006 12:16 GMT

There is something that you are not doing right. Send me the mail merge
main document if you wish and I will take a look at it.

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

> Yes I did
>
[quoted text clipped - 78 lines]
>> >> >> >
>> >> >> > Look forward to your response

Reply to this Message

Graham Mayor - 20 Jun 2006 11:12 GMT

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

Signature

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

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

> Help - I noticed there was information provided earlier, however I
> have found this unhelpful.
> When I merge a percentage it is coming across as a decimal, I have
> tried the DDE option and this has not worked.
>
> Look forward to your response

Reply to this Message