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

    Can I change the cell format in Excel sheet?

    Asked by Web_Ghost on February 11, 2011 at 10:13 PM

    At the moment the excel report sheet shows some cells as ''numbers'', which is what I want, but it shows to two decimal places. Is there a way I can change it to display NO decimal places (online, before downloading/saving) - to show only the whole numbers? Not a big deal, it would just make the sheet easier to read, that's all.

    Thank you

  • Profile Image
    JotForm Founder

    Answered by aytekin on February 14, 2011 at 11:53 AM

    We currently do not have a way to define the field formats. I added this to our feature requests list. Thank you.

  • Profile Image

    Answered by Web_Ghost on February 16, 2011 at 11:47 PM

    Thank you, aytekin. It would be a good feature.

  • Profile Image

    Answered by Wendy on September 19, 2012 at 04:28 PM

    Along those same lines, I am collecting credit card numbers.  When I download to excel, it saves them in "scientific format" and rounds the last two digits.  Obviously, this is not a good thing.  I delete the entries after I download them so that the numbers aren't out there. 

    Any suggestions??

  • Profile Image

    Answered by jeanettebmz on September 19, 2012 at 04:43 PM

    Hello Wendy

    I have opened a separate thread to take care of your case here

  • Profile Image
    JotForm Support

    Answered by EduardoMendez on September 19, 2012 at 04:49 PM

    To be able to format a cell on a spreadsheet a good suggestion would be to use our Google Drive integration.  Even though you must be careful not to edit the spreadsheet content, you can sort it and format the cells as you wish.

    As per your particular case Wendy, please take a look at the new thread that was opened for your case.