Scientific notation with negative exponents (ie very small numbers)

I can’t seem to get either the Excel reader or the string to number nodes to accept numbers in scientific notation with negative exponents e.g. 4.345E-9

Hi @cAy74g4A,

welcome to the Forum.

Could you please provide (upload) an example of your issue. Otherwise we are not able to come up with a solution or be able to support you.

Did you checked if it is not only a rendering issue? Very small values often displayed as 0. Changing the render option for the column to full precission then shows the value.



Thank you, morpheus! It indeed turns out to be a rendering issue (didn’t think of that since none of the programming languages I use exhibit this behavior).


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.