Percentage cells from excel showing scientific numbers

[jmckenna97]

Hello, 

I have a formatting issue when importing as seen below(In Alteryx)

They need to be displayed in the below format (as it is in Excel)

I have tried playing around with format and the field types and have no luck. 

Can someone advise? 

[mceleavey]

Hi @jmckenna97 ,

can you provide your workflow and some mock data representing your problem?

Thanks,

M.

[KerryW · Accepted solution]

Changing your input number to Fixed Decimal (I used 19,9) I don't the scientific output

I used this formula to get the percentage- 2 decimal places:
tostring(
([Number])*100,2)
+ '%'