Hello,
when i upload an excel file with numbers and with a column header ‘12/2019’, then Knime recognized that column is a string. In Excel there are only two decimal points visible but the number has more than two decimal points. For instance in Excel is visible 0,51 but the number has five decimal points 0,51456. The problem is: Knime said this column is a string and read only the number with two decimal places like 0,51. And if I use the string to number node after the excel writer then there is also only 0,51 visible and not 0,51456. But I need the exact number for calculation, otherwise I got rounding differences. Is there a possibility in the excel reader with that I can define the format of a column by my own?