Issue in String to number Conversion

[ravi13]

Hello Knime Expert,

I just need some help.
When I am converting Column Using node: String to Number
It is showing following error:
" Values in 11790 cells could not be parsed, first error: ‘17.52’"

I have shared Excel file for conversion.

Export Script 3.xlsx (76.7 KB)

[quaeler]

Hi - It would be more helpful if you shared a screenshot of the output from the node providing input to String to Number node, and the configuration dialog of the StN node as well.

[izaychik63]

This works without errors in KNIME 4.1.2

[Lingbin]

Hi
check thousands separator as below under string to number config:

[ravi13]

Thank you So much.
My issue has been resolved, using this.

[ravi13]

Thanks for the reply, I just missed out thousand seperater…
I got answer.