Can not sum Excel data from Microsoft Forms

[Dave I]

Any help would be appreciated.

I have a form that writes to an online Excel file. Works okay but I would like to do some totals of some of the columns afterwards. However, it adds an apostrophe before the number. How can I get forms to stop doing this, or at least find a quick way to reformat the cells to be totalled?

[ArviLaanemets]

Probable solution (I don't use Excel forms myself, neither I use Excel online):
You must have the column(s) in online Excel file formatted as Numeric/General;
Form field(s) you use numeric values must be formatted an Numeric/General. And in case there is VBA used for data input, be sure the data format is right one too.

In case you have in online file a lot of data with leading apostrophes:
1. Format columns meant for numeric data as Numeric/General;
2. Select range(s) you want to convert;
3. Activate Replace, into search field enter apostrophe, leave replace field empty, and click Replace All!