SoftMaker.com

Using textBox is also a good approach. Thank you!

Probably what is happining is that TextMaker is trying to convert the string to a value using Try Catch, so "00025" can converted to a number resulting in a true acceting the Try and " 00025" is failing so going to Catch returning a string.

But ...

Here I left an exemple of the number issue.

One approach that can help us is to use space in the begin of the string. That work around solve the problem.

Sorry Jossi. Since you said that cant replicate it I started everything again and, my shame, I was saving in .doc file. :o

After I saved it to .tmpx the problem with the variables disappeared. MY fault.

The only thing that I cant fix is about numbers now. This ID number that can be 000025 for ...

Hi Jossi, thank you!

About Total: is just an example, I did it but could be insert a "$" or "%".

And the value is not a value, but a string that represent a Budget file...Like an unique id. They use zeros in the left side too.

What is curious is if I use it: BUDGET = "05022513" will work, but in ...

STRING(5*5;1)+"%"



But there are another BIG problem. I am losing variables registers when I save, close and open again the file. "Unkown Variable"

And even using: BUDGET = STRING("05022513";1) I am still receiving as value 5022513

Hi. I am trying to concat two different values in a table cell:
I have something like: #B1*#C1. It is working fine resulting a number.

But I also want to add "Total: " string value.

I tried to search for concat, concatenation but no luck.

So the ideia is "Total: " & #B1*#C1 (this is not working ...