How to get the % symbol in Survey123 form

354
4
Jump to solution
02-17-2022 08:28 AM
by Anonymous User
Not applicable

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?

Tags (2)
1 Solution

Accepted Solutions
DougBrowning
MVP Honored Contributor

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.

Hope that helps

View solution in original post

4 Replies
DougBrowning
MVP Honored Contributor

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.

Hope that helps

by Anonymous User
Not applicable

Thank you! How do you force the format to string?

0 Kudos
by Anonymous User
Not applicable

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!

DougBrowning
MVP Honored Contributor

Just right click then format in the cells.

0 Kudos