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

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!

Try to change Double format as on picture

2 Likes

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