#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? |
#2
|
|||
|
|||
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! |
|
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 |