InfoPath Dev

On submit, field Confirmation renders the following text "Manual Debit Total $ [TOTAL]" where [TOTAL] is a reference to the field TOTAL. 

The problem is, when the total is rendered in the confirmation field, it is displayed in scientific value.  For example, field TOTAL displays 3639.10 but when the confirmation field is populated, it shows "Manual Debit Total $3639.100000000003"  I have figured out how to ensure the total displays correctly in the SharePoint list by creating a separate column, Totalv2, calculate per the following equation:  =Total*100/100. 

 Is there formula to display the total in the confirmation field as a text value?

is your confirmation field set as text? I played with this a bit and was able to find a simple solution I had to fields, field1 was a number, set to double and currency. field2 was plain text. I set default value of field2 to = this

concat("$", substring-before(field1, "."), ".", substring(substring-after(field1, "."), 1, 2))

give it a try and let me know

Worked like a charm.  Thanks!