Notifications
Announcements
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?
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
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" )
You made it very easy for me. Thank you!
Thanks @clepe1966 - you're welcome.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
In our never-ending quest to improve we are simplifying the forum hierarchy…
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Kalathiya 368 Super User 2026 Season 1
WarrenBelz 318 Most Valuable Professional
