Can not sum Excel data from Microsoft Forms

		Microsoft Office Forums > Microsoft Excel > Excel
Can not sum Excel data from Microsoft Forms

FAQ

Thread Tools

Display Modes

04-09-2020, 12:12 AM

Dave I

Windows 10 Can not sum Excel data from Microsoft Forms

Office 2019

Novice

Join Date: Apr 2020

Posts: 1

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?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Outlook 2013 Forms (how to questions)- Quick opening of a form file & Linking form's data to Excel	gamin2407	Outlook	0	01-21-2017 10:14 PM
Word Forms - importing data from one form to another	cliffoth	Word	7	09-25-2014 05:17 PM
Forms Data Using Developer Tab	scbarton	PowerPoint	1	03-15-2012 09:24 AM
How to create editable Microsoft Word forms?	Mrningstar	Word	1	05-03-2010 07:54 PM
Forms - Combo Box Linking data	tomkat	Word	1	04-23-2010 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:16 AM.