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

    Currency format in Spreadsheet widget.

    Asked by HOWNewForms on June 14, 2015 at 10:10 PM

    How do I set a field as currency instead of just a numeric value?

    Is Wrap Text function available in an embedded spreadsheet?
  • Profile Image
    JotForm Support

    Answered by ashwin_d on June 15, 2015 at 02:37 AM

    Hello HOWNewForms,

    I am not sure if I have understood your question correctly. Do you mean to say that you want to display currency in the "Spreadsheet" instead of numeric?

    I am not sure why do you need currency type in spreadsheet widget. Do you want to display the currency symbol in the spreadsheet cell? Unfortunately we do not have any currency type format in the Spreadsheet widget. 

    I have moved your question related to "Wrap Text" in new thread and you will be answered here:  http://www.jotform.com/answers/588670 

    Thank you!

  • Profile Image

    Answered by HOWNewForms on June 16, 2015 at 03:20 PM

    My spreadsheet has a Unit Price column, quantity column and then Amount which is unit price X quantity.  The numbers appear, for example, Unit price of 50.00 and quantity 2 shows 100.00 in Amount column.  I want the numbers to show as $50.00 and $100.00.


    How do I do that?

  • Profile Image
    JotForm Support

    Answered by BJoanna on June 16, 2015 at 04:14 PM

    Unfortunately as my colleague already mentioned we do not have any currency type format in the Spreadsheet widget. 

    I would suggest you to add label to your Spreadsheet widget where you can notify your users that amount is shown in dollars.

    Hope this will help. Let us know if you need further assistance.