What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How do I format the calculation as currency

    Asked by mleppin on January 10, 2017 at 08:56 AM

    https://form.jotform.com/70054598538970

     

    How do I format the calculation as currency

    Page URL:
    https://form.jotform.com/70054598538970

  • Profile Image
    JotForm Support

    Answered by candy on January 10, 2017 at 10:10 AM

    Hello,

    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.

    Thank you.

  • Profile Image

    Answered by mleppin on January 10, 2017 at 11:45 AM
    Yes 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 | melissa.leppin@hotelplanner.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

    ...
  • Profile Image
    JotForm Support

    Answered by BJoanna 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.