08-19-2019 04:52 AM
I am collecting integers greater than zero, but entries are prepended by a single apostrophe in excel.
Is this not a bug?
08-19-2019 05:29 AM
08-20-2019 08:45 PM
08-21-2019 02:02 AM
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.
08-26-2019 05:54 AM
@Anders Krogsager i have the same issue
09-19-2019 05:06 PM
Same issue. Using for business. Not ideal. @Anders Krogsager
09-24-2019 03:21 AM
10-16-2019 04:51 AM
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!!