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.

BR

2 Likes

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).

BK

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