Convert negative numbers to numbers in brackets

[jamnanin (Naresh Jamnani)]

How do I convert the negative numbers in a column to numbers in brackets.
for eg. -100 becomes (100)

[arivu96 (Arivazhagan A)]

Hi @jamnanin,

Strnumber=Convert.Tostring(StrValue);
Check the number is negative
If condition strnumber.contains(“-”)

If yes
"("+strnumber.Replace("-","")+")"

Regards,
Arivu

[jamnanin (Naresh Jamnani)]

Thanks @arivu96 I will try it out