I have a name field which contain a mixture of strings and numbers.
Unfortunately, some of the strings are written in formats that triggers excel and alteryx to believe that they are scientific notation. E.g. 1E05.
Simply adding an apostrophe to the beginning of the cell does not prevent this as the data come out of the system I extract it from in the incorrect format because it is an xlsx file which convert the cells automatically.
They are not converted back simply by changing the cell data type in Alteryx and I cannot convert them using ToNumber() because some of them should be strings, not numbers.
Does anyone know how I can have Alteryx convert the data back into the correct format?
Thank you in advance.
