How to show parentheses in a negative number

Hi all,

What is the best practice to add the parentheses in a negative number to be "-40,000" to be "(40,000)"?

I'm new to this tool and appreciate your help.

Thank you in advance

Preparation

Accepted answers

I would do it with a formula like this

negative number.png

All comments

I would do it with a formula like this

negative number.png

Hi DavidP

It works perfectly. Many thanks for your support, really appreciate it!!

Hi DavidP,

Thanks for sharing the formula. I am wondering how to convert the negatif number as indicated in the exemple to (40 000) without ",".

Thanks for your insights !

Best

Olivia

thank you so much! I try to use the same formula but there is an error showing "resulted in a string but the field is numeric...Use ToNumber() if this is correct. May I know what shall I do to solve this data type error?

Fyi, my current data type should be "double"

thanks!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703