RTL Support for Hebrew/Arabic Text Mixed with Engl...

[LemonSorbet]

I'm new here so I do not know that many formula. I imported my tables from excel and I have it generate name of the product with product name + weight. However, I want the numbers that are generated in 2 digits format. And here is my current formula :

"[90.0]"&" "&{product name}&" "&{weight)}

I tried using Round(), but it didn't help.  

[LemonSorbet]

I've already tried this one, I had replied to another guy that some numbers are still incorrect. I added more digit in weight field to see if there are numbers behind it, but there isn't any. I tried to contact the support team too, but they havn't answer.

The weird part is that I put the same formula (yours and the other guy's), somehow now it shown different result as previously 2.20 was shown as ....2.03

[LemonSorbet]

You're just so INCREDIBLE. THANK YOU

[LemonSorbet]

The first weight part has to be INT though, or it will increase the number.

{productname}&" "&INT(weight)&"."&RIGHT(''&ROUND(weight*100),2)

[Alexey_Gusev]

You are welcome.
JFYI, extra digits are not visible until the number of digits hits Number type limit

In short, here is the explanation for Integer. I guess, something like this happens with floating point numbers, when you are trying to use text functions on them.