String Value but Alteryx adding a decimal point

[znooredeen004]

I have data that looks like:

Contract ID

12345

12AB03

TBD

Select tool shows that this column is define as string, however when I run the workflow and have the output I see that it has changed to:

Contract ID

12345.0

12AB03

TBD

How do I stop alteryx from adding that decimal point..

[alexnajm]

Can you send us the workflow replicating this behavior? It can just be a sample to make it easier

[znooredeen004]

Strangely enough this doesn't happen in the sample data. Its an excel file I have for work. In the excel file there are no decimal points or anything. Field is designated as string and has value like:

ABC123

123455

SAMPLE453

9876

Alteryx only turns 123455 or 9876 into 123455.0 and 9876.0 while leaving the other values in tact..

[apathetichell]

How are these values formatted in excel? What version of Alteryx are you running? Is amp on? sometimes Alteryx and excel try to be too smart.