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...
Wenjun Gong - Any update to this issue?
We would like to export Form responses to Excel then use a PivotTable to analyze the results but cannot without cleaning the data from text to number (as others have mentioned). Our surveymonkey export works much better.
It's possible the Form was created with text fields, then edited to add the number requirement later. Maybe that will help your team reproduce and fix??Unfortunately, creating a new survey is not ideal solution, the link has already been shared.
We would like to export Form responses to Excel then use a PivotTable to analyze the results but cannot without cleaning the data from text to number (as others have mentioned). Our surveymonkey export works much better.
It's possible the Form was created with text fields, then edited to add the number requirement later. Maybe that will help your team reproduce and fix??Unfortunately, creating a new survey is not ideal solution, the link has already been shared.