List of numbers from Excel - "String from Object" adds decimals

Hi all,

Currently I am getting some some numbers (codes) from Excel, and once they go through “String from Object” there are many more decimal numbers therefore the code does not match when trying to create dictionary

The format of the cells in Excel have been set to general, integer and text but the additional decimal places only appear after the String from Object node. Is there a simple alternative? Right now I am making it work by cutting characters but I feel like I’m missing something

Two thoughts, first: what is the result of replacing the string from object node with a+"" in a code block? I have a vague recollection that this method doesn’t have the trailing zero issue.

If that doesn’t work than have a look at this:

1 Like

Using the code block still results with many zeros :frowning:

Thanks for the link, I will try this cheat hehe

codeblockstring

Use the spring nodes version:

3 Likes

Thanks for sharing, will save for next time I run into this issue!

The replace “0000” with “” worked most reliably

I was having the same issue importing from excel and string from Object. I found out that part of the problem was excel. You have to store your numbers as text in a way that it gives you an error with green little triangle on the top left corner of the cell in excel. To do this you have to first change the cell format to text and then only input your number value.