Incorrect output

[praneshsapmm]

Dear Community ,

My workflow generates with few values in columns as show below . 

-4.26326E-14

I need to correct the values by changing to number. Is there anyway Alteryx can resolve. 

Thanks.

[DavidP]

So is that data in text format? If so, try changing the datatype to Fixed Decimal and select the number of decimals you require. If you need to convert it to a number first, try the ToNumber function

[praneshsapmm · Accepted solution]

Thankyou It worked.