Is there a way we can format a number in a column into currency type? I have a column named list price and I am adding a dollar sign. The only option I am seeing is a String Manipulation using this expression: join(“$”, string($List Price$)) but this will convert the data type to string not like in excel where is an option to format the number into currency type.
Your suggestions and opinion is greatly appreciated.
If the formatting was for Excel output and not within KNIME, then you should try out the Write to Excel Template node. It allows you to write into an existing formatted excel file with data from KNIME, or create a new file based on another template file.
You could also look into the Continental formatting nodes if your format is highly variable and you don’t have a lot of conditional formatting experience in Excel.
I would like to see currency or fixed decimal data types in KNIME as well though.