Microsoft Form Add Single Quote (') To My Number Responses

Hi @Nina

I was unable to reproduce the behavior in a test form, as the numeric responses appeared correctly in Excel. Could you please confirm whether you are opening the live workbook linked to the form or downloading a new Excel copy? Also, does this occur with every numeric question and in both Excel for the web and the desktop application? 

If possible, please create a new test form with a Text question set to Restrictions > Number, submit a few test responses, and check whether the same apostrophe appears. This will help determine whether the behavior is specific to the original form or its linked workbook. 

In the meantime, you can use a helper column to convert the responses into numbers: 

• Open the Excel response workbook. 
• Add a new column at the end of the response table. 
• Name the column Converted number. 
• In the first cell under the new heading, enter: *=[@[Question 1]]1 
• Replace Question 1 with the name of your Microsoft Forms question. 
• For example, if your question is How many kilometres did you travel?, use: =*[@[How many kilometres did you travel?]]1 
• 
• Press Enter and Excel should apply the formula to the remaining rows in the table. 
• Use the Converted number column in your calculations instead of the original response column. 

Feel free to share the requested details when convenient. I look forward to hearing from you.

Enforce Number Ristrictions in MS forms

• Name the column Converted number.