How do you merge a field as a percentage?

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

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


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

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

--

Graham Mayor - Word MVP

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


Merge Query wrote:
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

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

"Peter Jamieson" wrote:

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


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

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

Peter Jamieson

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

"Peter Jamieson" wrote:

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


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

Number wanted to display 7.22%

displaying :7.2218607677293434E-2

"Peter Jamieson" wrote:

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

Peter Jamieson

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

"Peter Jamieson" wrote:

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


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

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

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

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

"Merge Query" wrote in message
...
Number wanted to display 7.22%

displaying :7.2218607677293434E-2

"Peter Jamieson" wrote:

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

Peter Jamieson

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

"Peter Jamieson" wrote:

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


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

Yes I did

"Doug Robbins - Word MVP" wrote:

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

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

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

"Merge Query" wrote in message
...
Number wanted to display 7.22%

displaying :7.2218607677293434E-2

"Peter Jamieson" wrote:

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

Peter Jamieson

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

"Peter Jamieson" wrote:

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


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

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.

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

"Merge Query" wrote in message
...
Yes I did

"Doug Robbins - Word MVP" wrote:

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

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

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

"Merge Query" wrote in message
...
Number wanted to display 7.22%

displaying :7.2218607677293434E-2

"Peter Jamieson" wrote:

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

Peter Jamieson

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

"Peter Jamieson" wrote:

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


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

Does anyone have the solution to this problem? I have the exact same problem
and cannot seem to find the solution. I searched on Graham Mayor's page that
was linked, but am still not able to find the solution to the problem.

When I am at the spot where I wish to enter my merge info, I press CTRL+F9,
then I insert the merge field. When I go back to type in the "=" between the
brackets, or any of the info after the first close bracket, it no longer
works.

The correct result would be: 46.2500%

But instead I'm getting the following result:
{=0.462500000000000002*100 \#0.0000%}

"Doug Robbins - Word MVP" wrote:

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.

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

"Merge Query" wrote in message
...
Yes I did

"Doug Robbins - Word MVP" wrote:

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

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

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

"Merge Query" wrote in message
...
Number wanted to display 7.22%

displaying :7.2218607677293434E-2

"Peter Jamieson" wrote:

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

Peter Jamieson

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

"Peter Jamieson" wrote:

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


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