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


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?


Try to change Double format as on picture


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