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

  • Profile Image
    KB3HF
    Asked on February 08, 2021 at 01: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?

  • Profile Image
    Mike_G
    Answered on February 08, 2021 at 05: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.