display a negative number in parentheses

(0) Share

Report

Posted on by JohnnyDataGuy

How do you display a negative number in a textbox or label with parentheses instead of the minus sign?

For example my value is -5.

I want to show it as (5).

How do I format that in a label or textbox?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Hi @JohnnyDataGuy

Can you try to update the expression as:

"("&Match("-5", "-(?<numvalue>\d+)?").numvalue&")"

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (1)

Report
Hi @JohnnyDataGuy ,

Do you want to display a negative number within a Text Input Box or Label using parentheses rather than minus sign?

I have made a test on my side, please consider take a try with the following workaround:

Set the Default property of the Text Input Box2 to following:

If( IsMatch(TextInput1.Text, "\-\d+(\.\d+)?"), "(" & Substitute(TextInput1.Text, "-", "") & ")", TextInput1.Text )

On your side, you may need to type the following:

If( IsMatch(Text(YourNegativeNumberValue), "\-\d+(\.\d+)?"), "(" & Substitute(Text(YourNegativeNumberValue), "-", "") & ")", TextInput1.Text )

Please consider take a try with above solution, check if the issue is solved.

More details about the IsMatch function in PowerApps, please check the following article:

IsMatch function

Best regards,

Was this reply helpful? Yes No
JohnnyDataGuy 2 on at

Like (0)

Report

Thank You!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

For those who are wondering, there is an easier way...

ABS(-5)

😊

Was this reply helpful? Yes No