I have found apostrophes within the Excel Spreadsheet generated within the Responses from a MS Form.
if I create a Form asking for a number to be returned, lets say I am asking for respondents to tell me how many Kms they traveled. This number is entered into the background spreadsheet with a leading Apostrophe :( this means I have to remove apostrophes before I can manipulate the result data. THIS IS A PAIN!
Can we have the forms set up to not default to returning a text item, because this is why this is happening.
Agreed @Pete_McMorrow it is a pain. My employer forces me use the MS Suite, as we have an agreement with Microsoft and I'm sure a huge a huge amount of background processes that I'm not even aware of.
This 'little' task is just a tiny item I used to use 'Google Forms' to do and it used to work so easily. Now you can see the response from @Rob Elliott (which I must acknowledge thanks to, for his input) But look at the amount of hoops to jump through just to get MS Forms to accept a number format into a background spreadsheet...