 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2006Merge with Percentage field looses formatting
I'm having difficulty getting a percentage field from and Excel sheet to properly format when I merge it with Word. I've had no problems getting currency fields to format, but for some reason I can't get the percentages to format right. Here is the switch code I'm using: {MERGEFIELD "CAM_PERCENT" * 100 \#"##.##%"} This displays .0388% But I want it to display 3.88%. I've also tried using 0's and moving the decimal around, but it hasn't helped me any. I saw somewhere where someone used \#"0%", but this only displays '0%' when merged. I'm a bit new to this switching stuff. Does my version of Word have anything to do with this? Its Word 2003 Professional v. 11.5604 Thanks for the help  SignatureRone For the following values of CAM_PERCENT, the following field construction will give the results indicated { = { MERGEFIELD CAM_PERCENT } * 100 \# 0.00% } 0.0388 3.88% 3.88 388.00% SignatureHope 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 > I'm having difficulty getting a percentage field from and Excel sheet to > properly format when I merge it with Word. I've had no problems getting [quoted text clipped - 14 lines] > > Thanks for the help Doug -- I get a "Syntax Error" when I use the following switch: { = { MERGEFIELD CAM_PERCENT } * 100 \# 0.00% } I also tried connecting using the DDE stuff, but I lost all my fields during the merge, and there are a lot of fields to lose. I think at this point I'd rather try to get the percent stuff to work. I just don't understand why it works fine for currency fields, but the percent fields it does not. ...any ideas why? SignatureRone > For the following values of CAM_PERCENT, the following field construction > will give the results indicated [quoted text clipped - 22 lines] > > > > Thanks for the help All the {} need to be the special field braces you can insert using ctrl-F9, not the ordinary { and } characters you can insert using the keyboard. that's my best guess as to what's wrong, anyway... Peter Jamieson > Doug -- I get a "Syntax Error" when I use the following switch: { = { > MERGEFIELD CAM_PERCENT } * 100 \# 0.00% } [quoted text clipped - 40 lines] >> > >> > Thanks for the help It worked! Thanks Peter. You were exactly right. I was typing in the {} instead of using CTRL-F9 to insert them. I've been messing around for hours on that! Thanks again for your help. Must be a common newbie mistake. Thanks again! SignatureRone > All the {} need to be the special field braces you can insert using ctrl-F9, > not the ordinary { and } characters you can insert using the keyboard. [quoted text clipped - 46 lines] > >> > > >> > Thanks for the help Thank you so much! I wish I had read this about 2 hours ago! > All the {} need to be the special field braces you can insert using ctrl-F9, > not the ordinary { and } characters you can insert using the keyboard. [quoted text clipped - 46 lines] > >> > > >> > Thanks for the help See http://www.gmayor.com/formatting_word_fields.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I'm having difficulty getting a percentage field from and Excel sheet > to properly format when I merge it with Word. I've had no problems [quoted text clipped - 11 lines] > > Thanks for the help There is certainly nothing wrong with using switches, but the problem is solved in a more complex manner than is necessary. In Word, select Options from the Tools menu, and then select the General tab. Put a check in Confirm Conversion at Open and click OK. Henceforth, when merging from Excel, you will be given a choice of conversion protocols while attaching your Excel data file to the Word document. Choose DDE. Using this solution you need never be concerned in the future when merging formatted data, currency, percentage, date, etc, not only from Excel but Access as well. Except in extrodinary circumstance, forget that switches even exist. Just always choose DDE. > I'm having difficulty getting a percentage field from and Excel sheet to > properly format when I merge it with Word. I've had no problems getting [quoted text clipped - 11 lines] > > Thanks for the help I thought this was a great suggestion and tried it right away, however, there is a huge delay during the merge and the connection times out and the merge is not completed. Any ideas about that? > There is certainly nothing wrong with using switches, but the problem is > solved in a more complex manner than is necessary. [quoted text clipped - 23 lines] > > > > Thanks for the help DDE is less reliable, which presumably is why Microsoft changed it as default. Use switches http://www.gmayor.com/formatting_word_fields.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I thought this was a great suggestion and tried it right away, > however, there is a huge delay during the merge and the connection [quoted text clipped - 29 lines] >>> -- >>> Rone |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.