![]() |
#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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Formd | Mail Merge | 2 | 07-06-2022 01:21 PM |
![]() |
Karen615 | Excel | 8 | 04-09-2020 03:55 PM |
![]() |
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 |