 |
 | 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 / March 2004Switches for formatting a merge field
I have a WORD document that uses Excel workbook for data source. I have several fields that are monetary figures. I use the following switch to format the output { MERGEFIELD "Total_Interest_Owed"\#"$#,###.00"} Which results in the output of $ 45.57 My need is to have the first number "4" right next to the "$" so the display should be $45.57, but if I write the switch as $###.00 then the comma is gone if it equals or exceeds 1,000. How can I format a switch to show $45.57 and the also show $1,045.57 if the number exceeds 1,000. Any help would be appreciated, Thanks BOB Hi Bob, Use { MERGEFIELD "Total_Interest_Owed" \# ",$#.00"}  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP >I have a WORD document that uses Excel workbook for data source. I have > several fields that are monetary figures. I use the following switch to [quoted text clipped - 12 lines] > Any help would be appreciated, Thanks > BOB Thanks Doug, One more proplem I have the following statement that I want to eliminate a ":" when the number in the field is greater than 5. I have put this in place, but can't seem to make it work. Any help would be appreciated. {if {mergefield "nr)of)ees"} = "=<5" "" ":" \*mergeformat} What am I doing wrong as I'm returning the : all the time. Thanks BOB > Hi Bob, > [quoted text clipped - 16 lines] > > Any help would be appreciated, Thanks > > BOB Your syntax is wrong. Try {if {mergefield "nr)of)ees"} <= 5 "" ":" \*mergeformat} or {if {mergefield "nr)of)ees"} > 5 ":" \*mergeformat} Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Thanks Doug, > [quoted text clipped - 40 lines] >>> Any help would be appreciated, Thanks >>> BOB Hi again Doug, The only problem with that is the resulting display shows the , before the $. The display I'm getting now with that switch is ,$986.00. Any ideas as to what i'm doing wrong???? BOB > Hi Bob, > [quoted text clipped - 16 lines] > > Any help would be appreciated, Thanks > > BOB It's a language issue - see http://www.gmayor.com/formatting_word_fields.htm Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Hi again Doug, The only problem with that is the resulting display > shows the , before the $. The display I'm getting now with that [quoted text clipped - 33 lines] >>> Any help would be appreciated, Thanks >>> BOB Hi Graham, Thanks for responding. Unfortunately I've got my switch set up just like on your website and I still get the ,$986.00. Have no idea what i'm doing wrong. I've closed the WORD document out and reopened it and still get the same thing.... Any guidance??? Bob > It's a language issue - see http://www.gmayor.com/formatting_word_fields.htm > [quoted text clipped - 35 lines] > >>> Any help would be appreciated, Thanks > >>> BOB Hi Bob, Use the following switch \# "$,#.00" SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hi Graham, > Thanks for responding. Unfortunately I've got my switch set up just like [quoted text clipped - 47 lines] >> >>> Any help would be appreciated, Thanks >> >>> BOB This is wierd! The switch works correctly here with Windows set up with UK regional settings (Word 2003), but Doug tells me privately that it doesn't work for him. Change the $ for ? and I get the problem you have. I will add a note to the web page to try it both ways. In the meantime, Doug's correction should work. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Hi Graham, > Thanks for responding. Unfortunately I've got my switch set up just [quoted text clipped - 54 lines] >>>>> Any help would be appreciated, Thanks >>>>> BOB Thanks so much guys, hate to be the one that spotted the problem and I was almost afraid to say anything because you had already published it, but I thought I was doing something wrong. I'm using Office 2003 and have found other issues between some things and what I'm trying to do. Thanks for the time and patience, I appreciate it. Bob > This is wierd! The switch works correctly here with Windows set up with UK > regional settings (Word 2003), but Doug tells me privately that it doesn't [quoted text clipped - 60 lines] > >>>>> Any help would be appreciated, Thanks > >>>>> BOB No need to apologise, we welcome this type of information. My web page has now been altered. See if you agree with the revisions. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Thanks so much guys, hate to be the one that spotted the problem and > I was almost afraid to say anything because you had already published [quoted text clipped - 77 lines] >>>>>>> Any help would be appreciated, Thanks >>>>>>> BOB That certainly worked for me, very well. Your website looks like it gets the message across. You certainly solved my problem, thanks so much to ALL Bob > No need to apologise, we welcome this type of information. My web page has > now been altered. See if you agree with the revisions. [quoted text clipped - 80 lines] > >>>>>>> Any help would be appreciated, Thanks > >>>>>>> BOB Thanks for the feedback :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > That certainly worked for me, very well. Your website looks like it > gets the message across. You certainly solved my problem, thanks so [quoted text clipped - 95 lines] >>>>>>>>> Any help would be appreciated, Thanks >>>>>>>>> BOB |
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.