Set the decimals numbers after the comma

[roby9390]

Hi all,

I'm going crazy because I can't solve the decimal problem on my numbers.

I want all numbers in my app to have the following format "##.###,00". How can I do?

My browser is configured in Italian.

I'll give you an example of how the numbers come out now:

[Rusk]

Try adding a language tag, something like this:

Text(Value(YourData.Text),"##.###,00","it-IT")

[roby9390]

Hi @Rusk 

below the result of your suggestion:

3,1,00 is displayed instead of 3,10

[Rusk]

Hi @roby9390 ,

Oh I see, you want the "0" on the end.  Try 

Text(ThisItem.Rate; "#.00";"it-IT")

[roby9390]

Correct but I also want the dot as thousands separator

[Rusk]

Hi @roby9390 

Text(ThisItem.Rate,"[$-fr-FR]$#.###,00","fr-FR")

For some reason I couldn't get it to work with "it-IT"... try this though (should be the same functionality) 

[roby9390]

@Ruskit seems to work but why does it give me the dot even when the number does not reach the thousand?