Alteryx reading in number incorrectly

[wonka1234]

Hi,

I am reading in an excel, a cell has -0.07 (number format in excel) but alteryx reads it in as "-7.0000000000000007E-2" as a string. Why is this?

[alexnajm]

Maybe because it's a CSV? Maybe because it's being stored as text in Excel? Hard to tell without seeing it, but either way you can change it to a number with a Select tool

[apathetichell]

FYI - Alteryx is reading in the number correctly. It's just reading it in scientific notation. What's the numeric format in excel? if the formatting is set as scientific or something - that all makes sense. can you clarify if excel is showing it at as .07 but when you click you see that?

[TUSHAR050392]

Hey @wonka1234 It depends on how your excel data is. You can use this Alteryx knowledge article to convert scientific notation to numerical value - https://knowledge.alteryx.com/index/s/article/Converting-Values-from-Scientific-E-Notation-158346017...

Hope this helps.

[wonka1234]

@apathetichell It is in number format within the excel. See Attached. 

[alexnajm]

Either way, Alteryx can use it as a number correctly after making sure it's stored as a numeric data type in Alteryx

[apathetichell]

Is there another number/formatting in that column which could be impacting this?