Answered

Convert text to number format

(0) Share

Report

Posted on by Morgan78

169

Hello,

In my power app I need to convert text from this format "756.315,22" to this "756,315.22" (or from "55.220" to "55,220") in order to always have decimals depicted after point and thousands before comma.

I've already tried [Text( CurrencyColumnName, "[$-en-US]$ #.00" )] with absolutely no luck.

Any other suggestions?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (3)

Sort by

Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Iro_ ,

A bit messy, but this will do it

Text( Value( Substitute( Substitute( CurrencyColumnName, ",", "" ), ".", "" ) ), "[$-en-US]$#,###,##.00" )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Iro_

Another option you might consider is to convert the number from the language it is in to the one you want.

ex. : Text(Value(CurrencyColumnName, "es-ES"), "$#,##0.00")

Will produce $756,315.22 from "756.315,22"

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Iro_ :

Just some supplements,you could try:

Text(Value("756.315,22","de"),"#,#.##")

Best Regards,

Bof

Was this reply helpful? Yes No