Number Format in Google Sheets wrong

[aw15281]

Hello everyone,

I have an issue with writing numbers from KNIME into Google Sheets.

In KNIME the decimal number is seperated by the “.” in Google Sheets its the “,”.

Attached you will see the problem.

That is what i get in Google Sheets. Could you please help me ?

[armingrudd]

Hi @aw15281,
You can use the String to Number node and specify the decimal/thousands separators in the string and convert the string to number. Then you can modify the formatting by using the Number Format Manager node.

Or if you don’t want to convert the column type, then you can also use the String Manipulation node to replace the dots with comma. For example:

replaceChars($Total cost$, ".", ",")

[aw15281]

Thank you,

it worked for me.