Mail Merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jenny - 24 Aug 2007 16:22 GMT

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

Reply to this Message

Doug Robbins - Word MVP - 24 Aug 2007 21:46 GMT

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

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

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

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

Reply to this Message

Jenny - 27 Aug 2007 16:40 GMT

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.

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 3 lines]
> > My mail merge returns a percentage as 0.17563826086956522 instead of 18%.
> > How do I fix this? Thanks

Reply to this Message

Peter Jamieson - 27 Aug 2007 16:58 GMT

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

Signature

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

> Ok - I can now view the % sign. However, I still need to get it from .17%
> to
[quoted text clipped - 9 lines]
>> > 18%.
>> > How do I fix this? Thanks

Reply to this Message

Sue Heistand - 27 Aug 2007 18:30 GMT

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?

> If you want 0.1756 etc. to appear as 17.56% then use
>
[quoted text clipped - 19 lines]
> >> > 18%.
> >> > How do I fix this? Thanks

Reply to this Message

Peter Jamieson - 27 Aug 2007 18:47 GMT

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"

Signature

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

> Peter - that's great! How about when you want to merge data from excel and
> it
[quoted text clipped - 32 lines]
>> >> > 18%.
>> >> > How do I fix this? Thanks

Reply to this Message

Graham Mayor - 28 Aug 2007 08:47 GMT

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

Signature

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

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

> Ok - I can now view the % sign. However, I still need to get it from
> .17% to
[quoted text clipped - 16 lines]
>>> My mail merge returns a percentage as 0.17563826086956522 instead
>>> of 18%. How do I fix this? Thanks

Reply to this Message

Rate this thread: