integer input is formatted as string

Copper Contributor

I am collecting integers greater than zero, but entries are prepended by a single apostrophe in excel.

Is this not a bug?

screenshot.png

7 Replies
I have the same issue. I want to present the collected data in a pivot chart. When I manually convert the data to number in each cell then the chart works. Must be some way to change the format of data when exported to Excel.
Agreed this is a headache. Hopefully it's fixed soon.
In the meantime, this link has has some workarounds. Text to Column works well.

https://www.extendoffice.com/documents/excel/2868-excel-remove-leading-apostrophe.html#a1

To get rid of this issue need to apply the formula that is B3&":"&C3.

This will not allow the integer to be formatted as a string.

@Anders Krogsager  i have the same issue

Same issue. Using for business. Not ideal. @Anders Krogsager 

This is new behaviour that wasn't present a couple of months ago, I hope this is fixed soon. I import the values from the forms into access, and it crashes on the text fields that are supposed to be integers if I don't manually convert them first.

@Anders Krogsager 

I have a problem: the excel form generated my MS Forms, put an apostrophe before the number or text...so the pivot doesn't work... is it a bug? started few weeks ago!!

 

 

msforms.JPG