![]() |
#1
|
|||
|
|||
![]()
I did some research but did not find a solution, so I am coming to the experts.
I need to round off a dollar value to the nearest dollar amount with a mergefield. Example if my figures show 549.36 (.49 or less) then my value should merge 549.00. If it is .50 or higher, then the dollar value would merge 550.00 I tried { MERGEFIELD Debt \#$,0.00} but it did not round of the dollar value. |
#2
|
||||
|
||||
![]()
That's as simple as:
{MERGEFIELD Debt \#$,0}.00
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Wow that was very simple.
I tested rounding both up and down and it works Thank you Paul. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Karen615 | Excel | 8 | 04-09-2020 03:55 PM |
help creating a dollar counter add-in | dstallworth | PowerPoint | 0 | 04-23-2017 12:49 PM |
mail merge with duplicate names but different dollar amounts | bh24524 | Mail Merge | 27 | 03-24-2014 01:15 PM |
Adding fixed % to different dollar values? | mikehende | Excel | 5 | 03-05-2013 01:50 PM |
Convert Dollar amount to text | GeorgeLawshe | Word | 0 | 03-07-2010 10:17 PM |