web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Set the decimals numbe...

Power Apps

Unanswered

Set the decimals numbers after the comma

(0) Share

Report

Report

Posted on by roby9390

105

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:

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (0)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Try adding a language tag, something like this:

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

Was this reply helpful? Yes No
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rusk
below the result of your suggestion:

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

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @roby9390 ,

Oh I see, you want the "0" on the end. Try
Text(ThisItem.Rate; "#.00";"it-IT")

Was this reply helpful? Yes No
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!

Correct but I also want the dot as thousands separator

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
roby9390 105 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No

Join the conversation