 |
 | 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 / May 2007Merge Field Currency Switch Rounding
I am working with MS Office 2003 and trying to round a merge field to currency rounded to the nearest $1K. I've got the decimal rounding handled. Thanks in advance for any input. You should be able to find out how to do this in fellow MVP, Macropod's Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=365442  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 am working with MS Office 2003 and trying to round a merge field to > currency rounded to the nearest $1K. I've got the decimal rounding > handled. > > Thanks in advance for any input. I think this one needs Macropod's further attention. In the meantime { IF{ =MOD({Mergefield Fieldname },1000) } < 500 "{ ={ =INT({ ={ =ROUND ({ Mergefield Fieldname},0) }/1000 }) } * 1000 \# ",$0" }" "{ ={ =INT({ ={ =ROUND ({ Mergefield Fieldname},0) }/1000 }) } * 1000 +1000 \# ",$0" }"} is not very elegant but it appears to work :) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > You should be able to find out how to do this in fellow MVP, > Macropod's Word Field Maths 'tutorial', at: [quoted text clipped - 6 lines] >> >> Thanks in advance for any input. For positive amounts, { =round({ MERGEFIELD myamount } / 1000,0) \#",$0K" } ? (All the {} have to be the field code braces you can insert using ctrl-F9, not the ordinary keyboard characters) Peter Jamieson >I am working with MS Office 2003 and trying to round a merge field to > currency rounded to the nearest $1K. I've got the decimal rounding > handled. > > Thanks in advance for any input. That's certainly better, but not as much fun ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > For positive amounts, > [quoted text clipped - 11 lines] >> >> Thanks in advance for any input. I get some amusement from the fact that an organisation that's dealing in $ amounts large enough that they want to round them to thousands of dollars can't work out how to do it. But not a lot :-) Peter Jamieson > That's certainly better, but not as much fun ;) > [quoted text clipped - 13 lines] >>> >>> Thanks in advance for any input. It's probably someone else's money ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > I get some amusement from the fact that an organisation that's > dealing in $ amounts large enough that they want to round them to [quoted text clipped - 27 lines] >>>> >>>> Thanks in advance for any input. It usually is :-) Peter Jamieson > It's probably someone else's money ;) > [quoted text clipped - 29 lines] >>>>> >>>>> Thanks in advance for any input. Hi all, Perhaps the following would suit the OP better: {=ROUND({MERGEFIELD myamount},-3) \# "$,0"} Cheers Signaturemacropod [MVP - Microsoft Word] ------------------------- > For positive amounts, > [quoted text clipped - 11 lines] >> >> Thanks in advance for any input. I knew you'd have a plan ;) Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> > Hi all, > [quoted text clipped - 18 lines] >>> >>> Thanks in advance for any input. WOW! Thanks to all for the prompt responses, with editorial... levity makes the world a better place! BTW, Yes it is someone else’s money-surety for land development. You all have my sincere respect and admiration. Cheers! > I knew you'd have a plan ;) > [quoted text clipped - 20 lines] > >>> > >>> Thanks in advance for any input. World domination!!! Signaturemacropod [MVP - Microsoft Word] ------------------------- >I knew you'd have a plan ;) > [quoted text clipped - 20 lines] >>>> >>>> Thanks in advance for any input. For a moment I thought you said "Word domination" :-) Peter Jamieson > World domination!!! > [quoted text clipped - 22 lines] >>>>> >>>>> Thanks in advance for any input. There's a difference? Signaturemacropod [MVP - Microsoft Word] ------------------------- > For a moment I thought you said "Word domination" :-) > [quoted text clipped - 26 lines] >>>>>> >>>>>> Thanks in advance for any input. I'd say "an 'ell of a difference" except then I'd have to kill myself... Peter Jamieson > There's a difference? > [quoted text clipped - 28 lines] >>>>>>> >>>>>>> Thanks in advance for any input.
|
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.