How to convert text to number and vice versa

Hi i searched the forum but couldnt find an answer. How can i convert a text from a list to a number?

1 Like

if the text is already numerals then just add 0 to it or multiply it by 1

image

1 Like

Right. And to convert a number to text, you can join it with an empty string ("").

@overturner If you’re needing to convert a list to a number… can you explain that? Do you actually mean a list variable/value? Or do you just mean a text string? Can you give an example?

2 Likes

For example i have a list : 2.456 , 3.256 , 562.234 , 21.56
Then i want to add all these
So i use a sum of list function and it gives me the actual sum. But when i dont give it a defined list then it gives me 2.4563.256562.234 etc
image
My code :
image

1 Like

You need to use a loop and add the individual entries by adding 0 and then add it to the running sum.

2 Likes

:partying_face: :partying_face:
Thank you so much @muneer and @tatiang
My issue is resolved. What i had to do :

1 Like