Flipping a value from positive to negative

I have a variable that is assigned a positive value during a read cell. However, when I need to paste this variable, I need to paste as a negative number. How do I “flip the sign”

Thanks

@RPANovice1 If you have + symbol means than replace with - symbol

Hi @RPANovice1,

As Indra mentioned you have to use replace method.

Import system.text.regularexpressions

Regex.replace(“+123”,“+”,“-”)

If it’s stored as a numeric value (integer, double, decimal, etc) then you can multiply by -1

1 Like