View Single Post
 
Old 04-09-2020, 12:12 AM
Dave I Dave I is offline Windows 10 Office 2019
Novice
 
Join Date: Apr 2020
Posts: 1
Dave I is on a distinguished road
Default Can not sum Excel data from Microsoft Forms

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?

Reply With Quote