I saw someone posted a tip of "Formatting numerical values for Web", and it only works for 12 digits. I have a better way to format a numeric value into a currency.
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
REM "---- 2 decimal places"; fv := valueTobeFormated; @Text(fv;"C,"); sample input 99999 sample output $99,999 REM "---- no decimal places"; fv := valueTobeFormated; @Text(fv;"F0C,"); sample input 99999.88 sample output $99,999.88