Formatting cells in form

  • Profile Image
    braultp
    Asked on January 10, 2018 at 09:39 AM

    Hi.  I wonder if it would be possible to format a cell in Currency, as we do in  Excel.

    In the form I created, I used the calculation widget to figure the cost of attending a meeting.  It would appear more professional if the attendee could see his cost as "$250.00" rather than "250" as it currently shows.

    Thank you

  • Profile Image
    BJoanna
    Answered on January 10, 2018 at 11:03 AM

    You can add the dollar sign in front of the calculation. 

    How to Perform Form Calculation Using a Widget

    1515599729total.JPG

    Here is my demo form: https://form.jotform.com/80094311951957 

    Feel free to test it. 

    If you have any issue to set this on your form, provide us an ID of the form you are working on and tell the name of the field to which you want to add the dollar sign.  

  • Profile Image
    braultp
    Answered on January 10, 2018 at 12:09 PM

    Perfect.  Thanks.  It took me a few tries before I noticed that you could put your cursor in front of the fieldname, and insert the "$" sign.