how to change rank letters in knime

[iCFO]

convert exp. number

Hi @jhoc, the String to Number node will actually convert 1.0E-5 to a Double, but the problem you are probably experiencing is that when you view it in a KNIME table, the standard renderer shows it as 0 so it looks like it hasn’t done it properly. (Of course 1.0E-5 is actually 0.00001 rather than 0.01 ) Example: [image] Changing the renderer by right-clicking on the column title, we can see that the Row1 value isn’t actually 0, but has been translated to the correct Double value: [image] …