how to change rank letters in knime

[Nico_Hendri_sut]

How to change the letter e or this power to 0.00000086?

[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] …

[takbb]

@Nico_Hendri_sut , welcome to the KNIME community.

If you are using KNIME 5.3, the “Round Double” node mentioned in the above post has been renamed to “Number Rounder”, and whilst it still performs the same tasks, some of the features (output mode) of the original node have been deemed “legacy” for some reason, but are still present.

The UI has changed with the update of the node, so it may appear confusing in reference to the post, but it still performs the same job.