How do I bulk change the sign (+ or -) in Excel
 

I have columns of negative numbers that I want to make positive and wondered
if I can do this is one stroke?

How do I bulk change the sign (+ or -) in Excel
 

Hi

One way is to put -1 in an unused blank cell. Copy it. Select your range
and then Edit/Paste/Special/Multiply.

Andy.
PS Make a backup first!

"Steve" wrote in message
...
I have columns of negative numbers that I want to make positive and
wondered
if I can do this is one stroke?

How do I bulk change the sign (+ or -) in Excel
 

Thanks Andy, I also found after posting of course, that all I had to do was
use the find and replace (- for a blank).

"Andy" wrote:

Hi

One way is to put -1 in an unused blank cell. Copy it. Select your range
and then Edit/Paste/Special/Multiply.

Andy.
PS Make a backup first!

"Steve" wrote in message
...
I have columns of negative numbers that I want to make positive and
wondered
if I can do this is one stroke?