News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Thousand separator wit...

Power Apps - Building Power Apps

Unanswered

Thousand separator with dot instead of comma

Like (0) Share

Report

Report

Posted on 8 Aug 2023 10:15:35 by 314mp_M0th4

126

Hello. I using the text function to format a number with a thousand separator as :

Text(Value, "#,###")

However I want a dot as a thousand separator and tried this :

"#.###"

But that only gives me a decimal separator as 50.00 instead of 50.000.000.

How can this be fixed?

Categories:

General Questions

All responses Img

All responses (4)

Answers Img

Answers (0)

timl 34,939 Super User 2025 Season 1 on 09 Jul 2024 at 23:04:15

Like (0)

Report

Re: Thousand separator with dot instead of comma

Thanks @clepe1966 - you're welcome.
clepe1966 14 on 03 Jul 2024 at 09:41:58

Like (1)

Report

Re: Thousand separator with dot instead of comma

You made it very easy for me. Thank you!
timl 34,939 Super User 2025 Season 1 on 08 Aug 2023 at 11:34:44

Like (1)

Report
Re: Thousand separator with dot instead of comma

Hi @314mp_M0th4

You can do this by specifying a suitable European language code as the 3rd argument to Text (eg, es-ES).

The benefit of this is that if you were to format decimals, this would also convert the decimal point separator to a comma.

Text(Value, "[$-en-US]#,###", "es-ES" )
WarrenBelz 146,645 Most Valuable Professional on 08 Aug 2023 at 10:58:44

Like (3)

Report
Re: Thousand separator with dot instead of comma

Hi @314mp_M0th4 ,

Try

Substitute( Text(Value, "#,###"), ",", "." )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps