Forum Discussion

dfox74's avatar
dfox74
Brass Contributor
Aug 31, 2019

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...
microsoft forms
Survey
Movaan's avatar
Movaan
Copper Contributor
Apr 27, 2020

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.

K_L_I_E_F's avatar
K_L_I_E_F
Copper Contributor
Nov 04, 2020

Movaan I was working on a responses that has number stored as text, and, since I needed to do a calculation based on the responses (to utilized its data and save time from moving the responses to another worksheet) I would need to convert the number stored as text into a number or value for a calculation to work. 
So I tried using the CLEAN function as you had suggested, though it removes the unprintable character ( ' ), there's still a need to convert the results into a values manually.
I found this VALUE ie. =VALUE(text or cell) function which convert the number stored as text to value. This can also be a work around.
All the best.

Resources