Formatting a merge field

Classic Servoy
1

Merging fields into letters (which are RTF in the DB) is working just fine, but now I have a small challenge:

How do I format a number field as currency? I.e. with a numeric value in the DB of say 45.3 I need that to appear as “$45.30” (currently it’s “45.3”.) - i.e. like using field formatting of “$#,##0.00”.

How do I do this?

Thanks,
Neale.

2

In the field property set the format value to “#.00” from the dropdown. This will diaplay a numeric value as currency.

3

Neale:
How do I do this?

Make a calculation using utils.numberFormat(…)