Percentages in word 2007 via merge with excel Barry Baker 10/27/2008 10:22:01 PM I am having trouble with converting the percentages from 14 digits ( or so )to a simple 54% display ( for example ) I have tried the *100 code but am having problems, perhaps i'm typing it in wrong, can someone paste me the code on here please

Re: Percentages in word 2007 via merge with excel "Doug Robbins - Word MVP" <dkr[ at ]REMOVECAPSmvps.org> 10/28/2008 12:07:53 AM Add the following formatting switch inside the closing } of the field code that is displayed when you use Alt+F9 to toggle on its display : \# ",0.00%" Delete the .00 if you do not want any decimal points. For more information on the use of formatting switches, 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 "Barry Baker" <BarryBaker[ at ]discussions.microsoft.com> wrote in message news:AB507F60-9DBB-46F2-9574-384333863951[ at ]microsoft.com... [Quoted Text] >I am having trouble with converting the percentages from 14 digits ( or so > )to a simple 54% display ( for example ) I have tried the *100 code > but > am having problems, perhaps i'm typing it in wrong, can someone paste me > the > code on here please

Re: Percentages in word 2007 via merge with excel "macropod" <macropod[ at ]invalid.invalid> 10/28/2008 3:35:41 AM Hi Barry, 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 controilled by the '0.00'. You can use anything from '0' to '0.000000000000000'. -- Cheers macropod [MVP - Microsoft Word] "Barry Baker" <BarryBaker[ at ]discussions.microsoft.com> wrote in message news:AB507F60-9DBB-46F2-9574-384333863951[ at ]microsoft.com... [Quoted Text] >I am having trouble with converting the percentages from 14 digits ( or so > )to a simple 54% display ( for example ) I have tried the *100 code but > am having problems, perhaps i'm typing it in wrong, can someone paste me the > code on here please

Re: Percentages in word 2007 via merge with excel Barry Baker 10/28/2008 10:28:07 AM macropod You are the BOY. That works perfectly, well done for explaining it simply. Brilliant.