Converting text type to number in alteryx

Question

Hi would like to ask if how can I convert or how to fix this issue as I try to import the excel in alteryx, it will change from decimal type to its original form.

Raw DataAlteryxExpected Output33312003.3312e-0063331200

can you help me with this one please

Manoj_k · Accepted Answer

hi @dunkindonut7777 try to convert the column in string type and the again change it in number in the next step it might fix the issue