- JotForm SupportcandyAnswered on January 10, 2017 at 10:10 AM
As I have checked, your question is already answered in the following thread link: https://www.jotform.com/answers/1027754-How-do-format-form-calculator-results-to-currency
Please check it.
- mleppinAnswered on January 10, 2017 at 11:45 AMYes The $ sign is visible but the calculation result is formatted like this: $1025886,00 trying to get it to look like $1,025,886.00. Once we report in a spreadsheet. The , will not roll up on the totals.
Melissa Le’ppin | EVP | CGMP
Ph: 1-800-898-1347 x230 | Fx: 1-888-559-8160 |
HotelPlanner.com | Meetings.com | email@example.com
cid:image001.png@01D12DD4.173F8310 meetings http://cdn.hotelplanner.com/Common/Images/fastest-growing66.png
GSA Contract: GS-33F-014CA } U.S. Communities Contract: EV2048
Connect with me on Linkedin and learn about our Bringing People Together partnership with Dylan Ratigan
- JotForm SupportBJoannaAnswered on January 10, 2017 at 01:28 PM
If I understood you correctly you want to separate thousands with a comma. To achieve this you will need to add commaSeparate option inside of your form calculation widgets.
You will also need to uncheck option for your second field to use comma as decimal point.
Here is my demo form: https://form.jotform.com/70094842349966
Feel free to test it and clone it.
Hope this will help. Let us know if you need further assistance.