Responses changing from number to text

%3CLINGO-SUB%20id%3D%22lingo-sub-832617%22%20slang%3D%22en-US%22%3EResponses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-832617%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20set%20up%20a%20survey%20in%20Forms%20to%20be%20used%20to%20count%20attendance%20for%20an%20organization%20on%20a%20weekly%20basis.%20There%20are%207%20different%20questions%20to%20input%20a%20number%20for%20the%20count%20in%20different%20sections.%20I've%20set%20the%20restrictions%20on%20all%20the%20questions%2C%20and%20when%20I%20pull%20up%20the%20survey%20on%20my%20phone%20browser%20I%20can%20see%20the%20answer%20box%20says%20%22The%20value%20must%20be%20a%20number.%22%20But%20when%20the%20answers%20are%20submitted%2C%20they%20are%20being%20changed%20to%20text%3B%20the%20Excel%20spreadsheet%20shows%20the%20answer%20is%20'59%2C%20instead%20of%2059.%20The%20cell%20format%20also%20shows%20that%20it%20should%20be%20number.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%20that%20I%20have%20some%20formulas%20built%20in%20the%20Excel%20spreadsheet%20recording%20the%20answers%2C%20and%20they%20obviously%20cannot%20work%20if%20the%20answers%20are%20text.%20Is%20anyone%20else%20dealing%20with%20this%20problem%3F%20Any%20ideas%20how%20to%20fix%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-832617%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Erestrictions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESurvey%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834438%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834438%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20issue.%20It%20changed%20all%20of%20a%20sudden%20a%20couple%20weeks%20ago%20and%20now%20I%20need%20to%20change%20all%20values%20manually%20to%20number%20before%20I%20can%20import%20the%20sheet%20into%20access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20microsoft%2C%20fix%20this...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885190%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885190%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398422%22%20target%3D%22_blank%22%3E%40dfox74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHaving%20the%20same%20issues%20on%20multiple%20different%20Forms%20%2B%20Excel%20pairings%2C%20except%20for%20one.%20Still%20haven't%20figured%20out%20the%20difference.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-885506%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-885506%22%20slang%3D%22en-US%22%3EThis%20still%20hasn%E2%80%99t%20been%20fixed.%20Waiting%20for%20Microsoft%20to%20address%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-968940%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-968940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398422%22%20target%3D%22_blank%22%3E%40dfox74%3C%2FA%3E%26nbsp%3BI%20am%20still%20having%20this%20issue%20with%20a%20form%20that%20worked%20great%20all%20of%20last%20year.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969074%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-969074%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437445%22%20target%3D%22_blank%22%3E%40DowneyECISD%3C%2FA%3E%26nbsp%3BMe%20too.%20Every%20week%20I%20have%20to%20go%20in%20and%20retype%20the%20entry%20in%20the%20Microsoft%20Excel%20results%20as%20numbers%2C%20then%20the%20sheet%20will%20calculate%20correctly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969075%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-969075%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F384250%22%20target%3D%22_blank%22%3E%40mrVazil%3C%2FA%3E%26nbsp%3Bare%20you%20still%20having%20the%20same%20issue%3F%20It%20is%20ongoing%20for%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-969077%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-969077%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392749%22%20target%3D%22_blank%22%3E%40Movaan%3C%2FA%3E%26nbsp%3BDid%20you%20ever%20find%20a%20reason%20for%20the%20difference%20for%20why%20the%20one%20is%20working%20as%20expected%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-982573%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-982573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398422%22%20target%3D%22_blank%22%3E%40dfox74%3C%2FA%3E%26nbsp%3BUnfortunately%20no.%20And%20no%20changes%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1023534%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1023534%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398422%22%20target%3D%22_blank%22%3E%40dfox74%3C%2FA%3E%26nbsp%3BI've%20just%20decided%20to%20forget%20this%20and%20use%20CLEAN-function%20to%20convert%20my%20answers.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1337713%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1337713%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F398422%22%20target%3D%22_blank%22%3E%40dfox74%3C%2FA%3E%26nbsp%3BI%20am%20having%20the%20same%20issue%20and%20it%20is%20very%20frustrating.%20Anyone%20figure%20out%20a%20solve%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339531%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339531%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F420604%22%20target%3D%22_blank%22%3E%40alyssat%3C%2FA%3E%26nbsp%3BI%20use%20as%20a%20work%20around%20CLEAN-function%20in%20a%20new%20column%20(ie.%20%3DCLEAN(%5B%40Number%5D)*1).%20This%20way%20you%20will%20have%20usable%20number%20that%20won't%20break%20your%20functions.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339553%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392749%22%20target%3D%22_blank%22%3E%40Movaan%3C%2FA%3E%26nbsp%3BWhile%20the%20issue%20can%20be%20resolved%20with%20the%20CLEAN%20formula%2C%20it%20is%20an%20extra%20step%20that%20should%20not%20be%20needed.%20The%20Form%20is%20setup%20with%20that%20field%20requiring%20a%20number%20and%20it%20should%20export%20into%20Excel%20as%20a%20number%2C%20like%20it%20used%20to.%20My%20problem%20still%20exists%20and%20requires%20the%20recalculations%20as%20my%20Excel%20data%20is%20being%20imported%20into%20an%20Access%20Database.%20When%20the%20number%20field%20remained%20a%20number%20this%20was%20not%20an%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1339555%22%20slang%3D%22en-US%22%3ERe%3A%20Responses%20changing%20from%20number%20to%20text%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1339555%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F437445%22%20target%3D%22_blank%22%3E%40DowneyECISD%3C%2FA%3E%26nbsp%3Bcouldn't%20agree%20more.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

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 restrictions on all the questions, and when I pull up the survey on my phone browser I can see the answer box says "The value must be a number." But when the answers are submitted, they are being changed to text; the Excel spreadsheet shows the answer is '59, instead of 59. The cell format also shows that it should be number.

 

The problem is that I have some formulas built in the Excel spreadsheet recording the answers, and they obviously cannot work if the answers are text. Is anyone else dealing with this problem? Any ideas how to fix it?

13 Replies
Highlighted

I have the same issue. It changed all of a sudden a couple weeks ago and now I need to change all values manually to number before I can import the sheet into access.

 

Please microsoft, fix this...

Highlighted

@dfox74 

 

Having the same issues on multiple different Forms + Excel pairings, except for one. Still haven't figured out the difference.

Highlighted
This still hasn’t been fixed. Waiting for Microsoft to address it.
Highlighted

@dfox74 I am still having this issue with a form that worked great all of last year.

Highlighted

@DowneyECISD Me too. Every week I have to go in and retype the entry in the Microsoft Excel results as numbers, then the sheet will calculate correctly.

Highlighted

@mrVazil are you still having the same issue? It is ongoing for me.

Highlighted

@Movaan Did you ever find a reason for the difference for why the one is working as expected?

Highlighted

@dfox74 Unfortunately no. And no changes here.

Highlighted

@dfox74 I've just decided to forget this and use CLEAN-function to convert my answers.

Highlighted

@dfox74 I am having the same issue and it is very frustrating. Anyone figure out a solve? 

Highlighted

@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.

Highlighted

@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.

Highlighted

@DowneyECISD couldn't agree more.