Mail Merge from Excel

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

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.

 

[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

 

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

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"

 

[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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>