Scientific Notation with XLS reader (Column has Strings and Doubles)

KNIME Analytics Platform
#1

Hello,

My excel file has a column which contains Strings and Doubles.

Render is identifying that the column is a String but the numbers are coming with Scientific Notation.

I have visited other topics where people are using the Number to String node, which works fine for all the numbers but removes the content from the records with texts/strings for this field. Is there a way to keep all my numbers as Strings without the scientific notation PLUS and the texts?

Thanks!

#2

Try to change Double format as on picture

image
image1280×1024 69 KB

2 Likes
#3

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