Formatting cells in form

  • braultp
    Asked on January 10, 2018 at 9: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

  • BJoanna
    Replied 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 Screenshot 10

    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.  

  • braultp
    Replied 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.