Sum a text to an integer

sharon95

I have a "number" that is actually a text. I want to sum it to an integer... How can I do this? thanks!

sharon95

solved

sharon95

solved

Wisa123

Use the EVALUATE Function to do this:
https://msdn.microsoft.com/en-us/library/dd338899.aspx

Just for other people with the same problem finding this thread.
Btw always include the solution before closing a thread, even if you managed to solve the problem yourself.