InfoPath Dev

Hi,

 I want to concatenate a field containing currency formatting with text in a Rich Text Box.

field1= $50,000.00

Text box formula --> concat("The amount is ", field1, " and it must be expended prior to March 01, 2014.")

 This formula returns this in the text box... The amount is 50000 and it must be expended prior to March 01, 2014.

I want this to show up (with currency formatting)... The amount is $50,000.00 and it must be expended prior to March 01, 2014.

 Thanks for the help!

 JF

field1 might be displayed as currency on its own but it's stored as 50000 not $50,000.

You could try something like:

concat("The amount is $", substring(field1, 1, 2), ",", substring(field1, 3, string-length(field1)))