I am trying to show a drop down menu of values 1-15%. Under label in the XLSForm, I typed 1%, 2%, 3%, etc. But when I launch the survey the values turn to 0.01, 0.02, 0.03 etc. Is there a way to keep the percentage symbol?
This is excel not 123 issue. You have to force excel to make it a string. But even that can be weird. For me I had to put a space between the number and percent sign then force the format to string in excel and that got it.
This is excel not 123 issue. You have to force excel to make it a string. But even that can be weird. For me I had to put a space between the number and percent sign then force the format to string in excel and that got it.
It looks like if you add ' before the number it automatically makes it a text. So '1% now shows up as 1%. Hopefully that will help you as well! Thanks so much!
