Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
I have a collection of formuals to change a currency numeric value to text.
Try this one
var number Value = Round([Open Amount],0.01);
var text Decimals = "." & Right(ToText(Int($value * 100)),2);
var text Thousands = If($Value>=1000,ToText(Int($Value/1000)));
var text Hundreds=Right(ToText(Int($Value)),3);
var text Words =
"$" & List(",",$Thousands,$Hundreds) & $Decimals;
Try this one
var number Value = Round([Open Amount],0.01);
var text Decimals = "." & Right(ToText(Int($value * 100)),2);
var text Thousands = If($Value>=1000,ToText(Int($Value/1000)));
var text Hundreds=Right(ToText(Int($Value)),3);
var text Words =
"$" & List(",",$Thousands,$Hundreds) & $Decimals;