Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
Conrad Klein Conrad Klein is offline
external usenet poster
 
Posts: 1
Default Mail merge in Word, from Excel, the merge results for a percentag.

Mail merge in Word, from Excel, the merge results for a percentage, i.e.
0.8942% shows incorrectly. Using "numeric picture switch" the closest I can
come is .0089%.
Any help would be appreciated.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
macropod[_2_] macropod[_2_] is offline
external usenet poster
 
Posts: 2,059
Default Mail merge in Word, from Excel, the merge results for a percentag.

Hi Conrad,

To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield. To do this:
.. select your mergefield, which will look something like «Percent»;
.. press Ctrl-F9 to wrap another field around it, thus { «Percent» };
.. edit the field so that you get {=«Percent»*100 \# 0.00%};
.. position the cursor anywhere in this field and press F9 to update it;
.. run your mailmerge.

Note: the precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.


--
Cheers
macropod
[Microsoft MVP - Word]


"Conrad Klein" Conrad wrote in message news
Mail merge in Word, from Excel, the merge results for a percentage, i.e.
0.8942% shows incorrectly. Using "numeric picture switch" the closest I can
come is .0089%.
Any help would be appreciated.


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word/Excel VBA mail merge fails with filtered results jm_dunning Mailmerge 1 July 9th 09 07:07 PM
Word 2007, How do I suppress blank line results in a mail merge? ckrumana Mailmerge 2 January 30th 09 10:16 PM
Mail Merge with Excel shows incorrect results Jan Mailmerge 2 September 17th 08 11:58 PM
Mail merge display results barjas Mailmerge 3 July 19th 08 03:04 AM
Save results of a mail merge katmagic[_2_] New Users 1 May 3rd 08 07:38 PM


All times are GMT +1. The time now is 05:28 PM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"