Form Submission Issue - Dropdown list with Integer values
In one of my sheets I have a dropdown column that has only integer values from 1-20 and it is restricted to these values only. Also, I have an online form where users before submitting data, they would select from the list any value from 1-20. This was working fine till last week. Now whenever the user submit the data using the form it appends .0 to the selected value. For example, if the user selected 5 from the dropdown list and click submit it appears in the sheet as '5.0 and this is causing issues on the formulas in my sheet and affecting the reports.