I have columns of negative numbers that I want to make positive and wondered
if I can do this is one stroke?
I have columns of negative numbers that I want to make positive and wondered
if I can do this is one stroke?
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" <[email protected]> wrote in message
news:[email protected]...
>I have columns of negative numbers that I want to make positive and
>wondered
> if I can do this is one stroke?
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" <[email protected]> wrote in message
> news:[email protected]...
> >I have columns of negative numbers that I want to make positive and
> >wondered
> > if I can do this is one stroke?
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks