Why not just use data formatting on your layout via the Inspector's data tab to supply the currency formatting? There can be cases where this approach is needed but if you can use data formatting on your layout, it's much easier.
NumToJText, while intended for use with Japanese language characters, can be used to insert a comma as a thousands separator:
NumToJText ( 1234 ; 1 ; 0 )
Will return: 1,234
NumToJText worked perfectly. Thanks
I don't have a layout. I'm working on creating a calculated field to assemble HTML formatted text.
Should I be using a layout? Can I make a layout format HTML text? That would maybe have been easier?
That does not sound like a case where you can use data formatting on a layout to get the needed results.