Convert negative numbers to numbers in brackets


#1

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


#2

Hi @jamnanin,

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

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

Regards,
Arivu


#3

Thanks @arivu96 I will try it out