How to have a dropdown show a number as a number and not text in an Excel download?

  • KB3HF
    Asked on February 8, 2021 at 1:51 PM

    I have a dropdown with single digits that download in Excel as a text number format instead of a true number. Can a dropdown be a number output?

  • Mike_G JotForm Support
    Replied on February 8, 2021 at 5:43 PM

    We would like to apologize for any inconvenience. I'm afraid that when submissions are downloaded into an Excel file the data downloaded are in text format by default. In your Excel file, however, you can select the entire column that represents the dropdown field in your form to change its format.

    Related Article: https://support.microsoft.com/en-us/office/convert-numbers-stored-as-text-to-numbers-40105f2a-fe79-4477-a171-c5bad0f0a885

    Feel free to let us know if you need any further assistance.