Jump to content
  • 0

Remove currency format in update form



I have three fields in an Update Datapage (ManagementExpenses, FundraisingExpenses, and TotalRevenue) that I need to format as only numbers (no currency symbols), if someone enters $11,500.51 it would render 11500.51 or $1,500,000 would render as 1500000.

I then use the numbers on a separate onchange function that calculates a % based on the three numbers in that same page.

Could anyone help me with a script to remove any currency symbols if the user inputs them?

I appreciate the help!

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

The fields are number fields and users need to input those three figures, management + fundraising + total revenue. Sometimes they will enter the number with a dollar sign and I want to remove that if it happens. My script is then calculating a percentage based on the figures they are entering on the page and then displaying that percentage to them.

So I need something that can remove any currency symbols or commas because it conflicts with my other script and the math doesn't calculate correctly.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...