H J,
Assume the values start in A2,
B2: = -Abs(A2)
and drag down as far as required.
For column B use any other convenient column.
Copy | PasteSpecial | Values the formla cells, either in situ or to replace
the original column A values.
---
Regards,
Norman
"jwoodruff77" <[email protected]> wrote in message
news:[email protected]...
>
Hi
Enter -1 into any free cell, and copy the cell.
Select your column.
Select PasteSpecial from menu, or from right-click dropdown list, and check
Multiply. OK.
--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )
"jwoodruff77" <[email protected]> wrote in message
news:[email protected]...
>
Hi Arvi,
Will this not convert negative values to positive values?
---
Regards,
Norman
"Arvi Laanemets" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> Enter -1 into any free cell, and copy the cell.
> Select your column.
> Select PasteSpecial from menu, or from right-click dropdown list, and
> check Multiply. OK.
>
>
> --
> Arvi Laanemets
> ( My real mail address: arvil<at>tarkon.ee )
>
>
> "jwoodruff77" <[email protected]> wrote in message
> news:[email protected]...
>>
>
>
"Norman Jones" <[email protected]> wrote in message
news:#fa#[email protected]
> Hi Arvi,
>
> Will this not convert negative values to positive values?
>
>
It will. The OP needs to do an IF statement in a free column as
=IF(A1<0,A1*-1,A1) and then do a copy-paste special-values I think.
Hi
Another way, when there are initially negative values in column, is to
select the column , and replace all "-" with nothing. After that OP can
continue multiplying the column with -1.
--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )
"Gordon" <[email protected]> wrote in message
news:[email protected]...
> "Norman Jones" <[email protected]> wrote in message
> news:#fa#[email protected]
>> Hi Arvi,
>>
>> Will this not convert negative values to positive values?
>>
>>
>
> It will. The OP needs to do an IF statement in a free column as
> =IF(A1<0,A1*-1,A1) and then do a copy-paste special-values I think.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks