How to turn negative value in excel into a positive one

Learn
1

I have a value that I moved from another worksheet and it is negative, but I need it to be positive. How do I do that?

2

@olsonse

Hey,

use math.abs(NegativeNumber)

3

After you’ve read the data (in this example into variable MyVar of type String), you can convert it with Math.Abs(CDbl(MyVar)).

2 Likes
4

can you show me what you mean?

5

You can use exactly the code I’ve posted, as long as you’ve read the data into a variable. To get the data, you’ll need to use read range before setting the variable and to write the data, you’ll need to use write range.

1 Like