Forum Discussion
2 Replies
- MarkShnier__YouQrew Legend You would need to convert the number to a text string in a formula field.
 This formula might work
 var number Value = Round([My Currency Field],0.01);
 var text Decimals = "." & Right(ToText(Int(Abs($Value) * 100)),2);
 var text Thousands = If(Abs($Value)>=1000,ToText(Int(Abs($Value)/1000)));
 var text Hundreds=Right(ToText(Int(Abs($Value))),3);
 If($Value=0,"$0.00",
 If($Value<0, "<font color=red>- ")
 &
 "$" & List(",",$Thousands,$Hundreds) & $Decimals)
 ------------------------------
 Mark Shnier (YQC)
 mark.shnier@gmail.com
 ------------------------------- cpansewiczQrew TraineeThis works great. How would I format Millions? Thank you