Conversion form number/scientific notation to string.

[EdwardCochrane]

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.

[binuacs]

@EdwardCochrane since Alteryx reading scientific notation as a string you cannot convert back to numbers, one option change the scientific notation from the excel (Select the cells, right-click and click Format Cells > Number tab > Number.) then feed to alteryx

[EdwardCochrane]

hanks, but the issue is primarily that it is reading what should be a string as a number/scientific notation.

E.g. 4E05 becomes 400000 when it should remains as 4E05. I cannot change this in excel because excel does the same thing.

[binuacs]

@EdwardCochrane can you try toString(toNumber([Field])) in Alteryx

[EdwardCochrane]

Unfortunately that just strips all of the required non-numerical information from the field.

[binuacs]

@EdwardCochrane Can you share the screen shot of the issue and expected result?