General

Re: Display number field value as text

ebonymb — Thu, 02 Aug 2012 13:05:19 GMT

Worked like a charm. Thanks!

Re: Display number field value as text

jaxkookie — Wed, 01 Aug 2012 21:53:46 GMT

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

Display number field value as text

ebonymb — Wed, 01 Aug 2012 21:11:12 GMT

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?