Forum Discussion
Responses changing from number to text
I've set up a survey in Forms to be used to count attendance for an organization on a weekly basis. There are 7 different questions to input a number for the count in different sections. I've set the...
This make sense when you think about it (but doesn't stop it from being annoying): the only question type I know of in MS Forms that has "restrictions" in the more settings is the Text question. The restriction is specifying that you can only use the numeric part of an alphanumeric answer, BUT it is still a TEXT question, and it is formatted as such in Excel.
What is needed in Forms is a actual Number question type, not a modified Text question tpe.
If there were an actual number type question in MS Forms than we could have actual number formatting options like # of decimal places, Integers only, currency, # of digits (as opposed to using Restrictions > Between), etc.
Again, not saying I approve of it...but if you remember that a "TEXT question with restrictions" is still a "TEXT question" at its core, then it makes sense.
What is needed in Forms is a actual Number question type, not a modified Text question tpe.
If there were an actual number type question in MS Forms than we could have actual number formatting options like # of decimal places, Integers only, currency, # of digits (as opposed to using Restrictions > Between), etc.
Again, not saying I approve of it...but if you remember that a "TEXT question with restrictions" is still a "TEXT question" at its core, then it makes sense.