You’re offline. This is a read only version of the page.
When trying to type in : Text(Price;"$##;###.##") I get the error message "nb is not supported"
Then the expression changed to : Text(Price;"[$-nb]$-##;###.##")
Try this (please be aware that I use an English system so that , should be mostly replaced by ; for you, like in Excel)
Text(123456789.123456, "[$-en-GB]$#,##0.00", "nb-NO")
On my system it shows this: $123 456 789,12
"To see the list of supported language tags, type Value( "1", ) in the formula bar or advanced view and scroll through the list of locales suggested for the second argument."
This comes from here: https://powerapps.microsoft.com/en-us/tutorials/function-language/
Also please have a look at these two threads:
https://powerusers.microsoft.com/t5/PowerApps-Forum/A-very-annoying-dateformat-bug/m-p/13180#M5796
https://powerusers.microsoft.com/t5/PowerApps-Forum/Format-decimal-and-float-numbers/m-p/13188#M5801
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
