Forum Discussion
integer input is formatted as string
I am collecting integers greater than zero, but entries are prepended by a single apostrophe in excel. Is this not a bug?
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
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