Currency text formatting New

[Anonymous]

How do I set up a field that has a currency value to appear in the format ######, ##

[v-siky-msft]

Hi @Anonymous ,

If you want to format the number, please try with Text Function.

Please try to set the Text property as below:

Text(ThisItem.Total; "######, 00")

Hope this helps.

Sik

[Anonymous]

Thanks Sik for the help!

But there was no effect continues in the same way with several zeros on the right not respecting the semicolon signs.

"R$" & Text(ThisItem.Total; "[$-pt-BR]####.##")

[HSheild]

Hi @Anonymous 

I think the Text formula might not be correct, there is a semi-colon (;) where there should be a comma (,) in the middle of the formula

Try "R$" & Text(ThisItem.Total,"####.##")

-----
 
If this post has answered your question please consider it for "Accept as Solution" or if it has been helpful give it a "Thumbs Up".

[Anonymous]

Hi @HSheild!

Same result.

[HSheild]

That is very strange as I tested that formula and it works fine. Did you try the formula without the square brackets part []?

[v-siky-msft · Accepted solution]

Hi @Anonymous ,

Could you show the example of the formatted number? 

I seem to have found your problem. In your region, decimals are separated by commas, so 'ThisItem.Total' should be a text, right?

It should be converted to Number and then formatted by Text function.

"R$" & Text(Value(Substitute(ThisItem.Total;".";",")); "[$-de]####,00")

Then, it should as  R$87,00

Hope this helps.

Sik

[Anonymous]

Sik!

Now it worked, thank you very much for your help and see you next time.

Hugs