[Jenny]

My mail merge returns a percentage as 0.17563826086956522 instead of 18%.
How do I fix this? Thanks

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


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

"Jenny" wrote in message
...
My mail merge returns a percentage as 0.17563826086956522 instead of 18%.
How do I fix this? Thanks

[Jenny]

Ok - I can now view the % sign. However, I still need to get it from .17% to
17.56%. Please don't direct me to Mayor's site again - I've look through
that site but I can't find what I need.



"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


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

"Jenny" wrote in message
...
My mail merge returns a percentage as 0.17563826086956522 instead of 18%.
How do I fix this? Thanks

[Peter Jamieson]

If you want 0.1756 etc. to appear as 17.56% then use

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

If you want it to appear as 18% then use

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

where all the {} are the special field code braces that you can insert using
ctrl-F9
--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jenny" wrote in message
...
Ok - I can now view the % sign. However, I still need to get it from .17%
to
17.56%. Please don't direct me to Mayor's site again - I've look through
that site but I can't find what I need.



"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


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

"Jenny" wrote in message
...
My mail merge returns a percentage as 0.17563826086956522 instead of
18%.
How do I fix this? Thanks

[Sue Heistand]

Peter - that's great! How about when you want to merge data from excel and it
does not show up properly. For example; we are merging a mailing list half of
which has the extension for the Zip code of (55503-4783) and half are just
the zip. It only merges the first half of the zip codes without the dash and
the rest are set to zero. Is there a way to fix this?

"Peter Jamieson" wrote:

If you want 0.1756 etc. to appear as 17.56% then use

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

If you want it to appear as 18% then use

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

where all the {} are the special field code braces that you can insert using
ctrl-F9
--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jenny" wrote in message
...
Ok - I can now view the % sign. However, I still need to get it from .17%
to
17.56%. Please don't direct me to Mayor's site again - I've look through
that site but I can't find what I need.



"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

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


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

"Jenny" wrote in message
...
My mail merge returns a percentage as 0.17563826086956522 instead of
18%.
How do I fix this? Thanks

[Peter Jamieson]

Have a look at

http://tips.pjmsn.me.uk/t0003.htm

In this case I would have a look at option 2 - change the way Word gets your
data to "DDE"

--
Peter Jamieson
http://tips.pjmsn.me.uk

"Sue Heistand" Sue wrote in message
...
Peter - that's great! How about when you want to merge data from excel and
it
does not show up properly. For example; we are merging a mailing list half
of
which has the extension for the Zip code of (55503-4783) and half are just
the zip. It only merges the first half of the zip codes without the dash
and
the rest are set to zero. Is there a way to fix this?

"Peter Jamieson" wrote:

If you want 0.1756 etc. to appear as 17.56% then use

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

If you want it to appear as 18% then use

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

where all the {} are the special field code braces that you can insert
using
ctrl-F9
--
Peter Jamieson
http://tips.pjmsn.me.uk

"Jenny" wrote in message
...
Ok - I can now view the % sign. However, I still need to get it from
.17%
to
17.56%. Please don't direct me to Mayor's site again - I've look
through
that site but I can't find what I need.



"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham
Mayor's
website at

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


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

"Jenny" wrote in message
...
My mail merge returns a percentage as 0.17563826086956522 instead of
18%.
How do I fix this? Thanks

[Graham Mayor]

You didn't look close enough. The quoted page covers exactly the
circumstances you outline - try looking under the sub heading 'Percentages'


--

Graham Mayor - Word MVP

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


Jenny wrote:
Ok - I can now view the % sign. However, I still need to get it from
.17% to
17.56%. Please don't direct me to Mayor's site again - I've look
through that site but I can't find what I need.



"Doug Robbins - Word MVP" wrote:

See "Formatting Word fields with switches" on fellow MVP Graham
Mayor's website at

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


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

"Jenny" wrote in message
...
My mail merge returns a percentage as 0.17563826086956522 instead
of 18%. How do I fix this? Thanks