Preserving fixed number of decimal places when converting to text
i have a calculation field (ItemSubtotal) which returns the numeric result of multiplying an item qty and an item price. if i am using us dollars i can simply format the field to preserve 2 decimal places and show a dollar sign. however, if the invoice is set up for a foreign currency (say, euro for example), i use a different layout to print the invoice and this layout contains a calculation field that returns a text result (e.g. ItemSubtotalForeignCurrency = ItemSubtotal & CurrencySymbol). so far this all works fine. the problem arises when the subtotal is an even amount (i.e. no cents, just dollars/euros/pounds, etc, such as 100€) and then it does not display the decimal places. i want it to display the result as: 100.00€. does anyone know how to do this. any help much appreciated.