Add/Display Decimals

Data.xlsx (9.5 KB)
I have the attached data in Excel with prices that have 6+ decimals, I need to display those prices in Knime with a minimum of 4 decimals and do calculations with them. When loading the data to Knime, I only get 2 or 3 decimals, any ideas about adding/displaying all decimals or at least a minimum of 4 decimals?

Excel:
image

Knime (only 2-3 decimals):
image

Hi @Alejandroc

After executing the Excel Readers, right click and open the File Table.

Right click on the Double column and choose the Full Precision option
image

2 Likes

That was easy. Thanks!

1 Like

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