- kkieferAsked on January 27, 2018 at 09:52 AM
In the past day our Excel output has changed and now column N (Weight Ticket Volume) is showing up as a Text and can't be summed in Excel.
We are converting the file over so these can be used. However, is this something that can be reverted back? Please advise
- JotForm SupportTREVONAnswered on January 27, 2018 at 01:26 PM
I have checked your form and I have noted that the submissions ID 3928149602667268862 may have entered text in the Weight Ticket(vol) field which may have been the cause the field changed to text. Kindly change the details of the submissions ID and export the submissions into the Excel sheet.
You may also need to consider validating the field to prevent users from entering any characters other than numeric characters. See demo below on how to validate the field.