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...
alyssat I use as a work around CLEAN-function in a new column (ie. =CLEAN([@Number])*1). This way you will have usable number that won't break your functions.
Movaan While the issue can be resolved with the CLEAN formula, it is an extra step that should not be needed. The Form is setup with that field requiring a number and it should export into Excel as a number, like it used to. My problem still exists and requires the recalculations as my Excel data is being imported into an Access Database. When the number field remained a number this was not an issue.
DowneyECISD couldn't agree more.