Turning a negative value to positive

Learn Academy Feedback
, , ,
1

Hello i am using a excel sheet ( thats a sql ) to retreive some numbers. Only problem its when i come to the negative number it only gives me 0. I have tries doing System.text.RegularExpressions.Regex.Replace(“-”+price_variable,“-”,“”)

but still spits out 0. How can i make a function that see if its a -number then it turns it into a positive and assign it to a varneneg ?=

2

@langsem Math.Abs(CDbl(“-1”)) will give you 1. In the same way you can try for your Purpose

1 Like
3

shall i change out the number one with my variable?

4

@langsem Yes, You can Always try and Check :smile:

5

still gives me 0

6

@langsem Can you tell me what is the Number you are trying to Convert ?

7

Worked now, could be a bug i guess

8

IMG_20211220_173327
IMG_20211220_1733271920×2560 607 KB

Can you explain me how can we achieve this
I need to change - to + and + to -

Price = math.abs(Price("-1).tostring)
It is correct
And then price variable should be which datatype

9

Thanks @supermanPunch this was helpful in converting -1,234 to 1,234, Can you help me on how to convert 1,234 to -1,234(Positive value to Negative value)