https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145211#M40612 <P>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?</P> Thu, 17 Feb 2022 16:28:13 GMT Anonymous User 2022-02-17T16:28:13Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145211#M40612 <P>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?</P> Thu, 17 Feb 2022 16:28:13 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145211#M40612 Anonymous User 2022-02-17T16:28:13Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145218#M40613 <P>This is excel not 123 issue.&nbsp; You have to force excel to make it a string. But even that can be weird.&nbsp; 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.</P><P>Hope that helps</P> Thu, 17 Feb 2022 16:40:52 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145218#M40613 DougBrowning 2022-02-17T16:40:52Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145239#M40615 <P>Thank you! How do you force the format to string?</P> Thu, 17 Feb 2022 17:17:12 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145239#M40615 Anonymous User 2022-02-17T17:17:12Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145245#M40616 <P>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!</P> Thu, 17 Feb 2022 17:22:49 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145245#M40616 Anonymous User 2022-02-17T17:22:49Z https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145255#M40617 <P>Just right click then format in the cells.</P> Thu, 17 Feb 2022 17:43:11 GMT https://community.esri.com/t5/arcgis-survey123-questions/how-to-get-the-symbol-in-survey123-form/m-p/1145255#M40617 DougBrowning 2022-02-17T17:43:11Z