Number Format in Google Sheets wrong

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.

Google Sheets
Google Sheets_2

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

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$, ".", ",")
1 Like

Thank you,

it worked for me.

1 Like

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