Code

Re: How can I convert string to decimal (currency)?

Hilary Stoupa — Tue, 04 Jan 2022 00:35:44 GMT

See attached sample. Save the file linked in this post header by right clicking the link. Then, right click the downloaded file and select design to open in design mode. Then you can preview, etc.

Re: How can I convert string to decimal (currency)?

erzon — Mon, 03 Jan 2022 23:13:59 GMT

I can't do that since the field type is text and it doesn't have any format.

Re: How can I convert string to decimal (currency)?

Hilary Stoupa — Mon, 03 Jan 2022 22:23:39 GMT

In the form, you could use a calculated value set to display the data as currency. Just add a calculated value to the form, select the field that has the value, and under the properties, format it as a decimal. You'll have the options then to set the currency settings.

Re: How can I convert string to decimal (currency)?

erzon — Mon, 03 Jan 2022 22:18:21 GMT

in form itself

Re: How can I convert string to decimal (currency)?

Hilary Stoupa — Mon, 03 Jan 2022 15:43:24 GMT

Display in your form? Or in your list?

Re: How can I convert string to decimal (currency)?

erzon — Thu, 30 Dec 2021 15:46:21 GMT

how can I make it in expression? just to display as currency but the field remains as text?

Re: How can I convert string to decimal (currency)?

Ramon84 — Sat, 10 Aug 2013 17:44:51 GMT

Thank you very much!!

Re: How can I convert string to decimal (currency)?

Hilary Stoupa — Tue, 09 Jul 2013 14:44:23 GMT

You could use a decimal field that has a default value of number(field) as the formula - with your string field in the number function.

Re: How can I convert string to decimal (currency)?

Ramon84 — Tue, 09 Jul 2013 14:30:07 GMT

Hi Hilary, Thanks for replying. I need to display and publish the string as currency to SP.

Re: How can I convert string to decimal (currency)?

Hilary Stoupa — Tue, 09 Jul 2013 14:19:49 GMT

Do you just need to display the string as a decimal value with the currency format? If so you can use a calculated value (expression box) for that.

How can I convert string to decimal (currency)?

Ramon84 — Tue, 09 Jul 2013 13:48:49 GMT

Hi, Help, please. I need to convert a string to decimal with currency format. How can I do that? Thanks in advanced.