Convert negative numbers to positive numbers

[kelly mort]

Hello,

Is there a way to convert all negative numbers In a column to positive numbers?

The thing is that, I am copying the value of cells with formulas to a different location with a vba script. So now I need a script that will convert any negative number to positive number. There may be blank cells in the column. And i am doing so to last used row.

Let's say column B is the target
Thanks

 

[nemmi69]

add in to the script to multiply by -1

 

[kelly mort]

add in to the script to multiply by -1

Okay
Thanks

 

[DougJ]

If you have a mixture of positive and negative numbers use the abs() function. That will change them all to positive.