How do I convert the negative numbers in a column to numbers in brackets.
for eg. -100 becomes (100)
Hi @jamnanin,
Strnumber=Convert.Tostring(StrValue);
Check the number is negative
If condition strnumber.contains(“-”)
If yes
"("+strnumber.Replace("-","")+")"
Regards,
Arivu
Thanks @arivu96 I will try it out