![]() |
|
#1
|
|||
|
|||
|
I'm in need of some expert help, i'm trying to switch a dollar amount into words, with dollars and cents. Below is what i have and it's returning to blank, not sure what i'm missing on this, but any suggestions would be greatly appreciated!
(Quote{Set Val {MERGEFIELD PCORevTotalCons}"=INT(Val)\* CardText} dollar{ =Int(Val)-1 \# "s;s;"}{ IF{=MOD(Val,1) \#0.00}>0 " and { ={ =MOD(Val,1)*100 \ # 0 } \* CardText } cent{ = INT(MOD(Val,1)*100-1) \# "s;s;" }" " and zero cents"}" \* First Cap} |
| Tags |
| mail merge, mail merge code, mail merge help |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Rounding of dollar value
|
Formd | Mail Merge | 2 | 07-06-2022 01:21 PM |
Sum Each Dollar Amount by Phase
|
Karen615 | Excel | 8 | 04-09-2020 03:55 PM |
Construction of a value to amount in words in mail merge
|
Marcia | Mail Merge | 2 | 08-08-2019 06:08 AM |
| help creating a dollar counter add-in | dstallworth | PowerPoint | 0 | 04-23-2017 12:49 PM |
| Convert Dollar amount to text | GeorgeLawshe | Word | 0 | 03-07-2010 10:17 PM |