How do we convert positive numbers into negative ones under one column?

Hi,

Put -1 in a cell and copy it

Select your column of positive numbers then
edit|Paste special
select multiply
Click OK
delete the cell with -1 in

Mike

"mviuya" wrote:

How do we convert positive numbers into negative ones under one column?

Put -1 in an empty cell, format it the same way as the others, copy it,
select the range with negative numbers and do editpaste special and select
multiply

If the numbers are in the same column you can use a help column

=IF(A10,-A1,A1)

copy down as long as needed, copy and paste special as values in place
and delete or copy and paste over the old column

--


Regards,


Peo Sjoblom

"mviuya" wrote in message
...
How do we convert positive numbers into negative ones under one column?

hi,

you can use an auxiliar cell type there "-1" (no quotes) copy it.

Select the numbers you would like to change and

and paste special Values - Multiply

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"mviuya" escreveu:

How do we convert positive numbers into negative ones under one column?

Hi Marcelo,
That was simple and helpful.
Thanks a lot.

M Viuya from the USA

"Marcelo" wrote:

hi,

you can use an auxiliar cell type there "-1" (no quotes) copy it.

Select the numbers you would like to change and

and paste special Values - Multiply

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"mviuya" escreveu:

How do we convert positive numbers into negative ones under one column?

hi, !

How do we convert positive numbers into negative ones under one column?

do you have any mixture of positives and negatives in "the range" ?
if so, and you want negatives "as is" and positives into negatives...
pretending "the range" in [A2:A35] -???-

try from vba-editor immediate window pane
(copy/paste or type) the following and press enter...

[a2:a35] = [a2:a35*-1^(a2:a350)]

hth,
hector.

Hola Hector,

What is wrong with the following:

Var1 = 30

[F4:F&Var1] = [F4:F&Var1*-1]

Note1: all values are positive
Note2: using F30 instead of F&Var1 works, but the column list will always be
different. (Yes, the actual variable is "Dim"ed and uses a routine to find
the last row.)

Question: what is wrong with the syntax? What is the proper way of
combining F with Var1? F&Var1 does not work.

Saludos


"Héctor Miguel" wrote:

hi, !

How do we convert positive numbers into negative ones under one column?

do you have any mixture of positives and negatives in "the range" ?
if so, and you want negatives "as is" and positives into negatives...
pretending "the range" in [A2:A35] -???-

try from vba-editor immediate window pane
(copy/paste or type) the following and press enter...

[a2:a35] = [a2:a35*-1^(a2:a350)]

hth,
hector.

I'd do something like:

Option Explicit
Sub testme01()

Dim myCell As Range
Dim Var1 As Long

Var1 = 30
With ActiveSheet
Set myCell = .Cells.SpecialCells(xlCellTypeLastCell).Offset(1, 1)
myCell.Value = -1
myCell.Copy
.Range("f4:F" & Var1).PasteSpecial _
operation:=xlPasteSpecialOperationMultiply
myCell.ClearContents
End With
End Sub

This is the same thing as putting -1 in an empty cell and then edit|copy that
cell.

Then select the range to adjust
Edit|paste special|multiply
and clearing that helper cell.

Billyruben wrote:

Hola Hector,

What is wrong with the following:

Var1 = 30

[F4:F&Var1] = [F4:F&Var1*-1]

Note1: all values are positive
Note2: using F30 instead of F&Var1 works, but the column list will always be
different. (Yes, the actual variable is "Dim"ed and uses a routine to find
the last row.)

Question: what is wrong with the syntax? What is the proper way of
combining F with Var1? F&Var1 does not work.

Saludos

"Héctor Miguel" wrote:

hi, !

How do we convert positive numbers into negative ones under one column?

do you have any mixture of positives and negatives in "the range" ?
if so, and you want negatives "as is" and positives into negatives...
pretending "the range" in [A2:A35] -???-

try from vba-editor immediate window pane
(copy/paste or type) the following and press enter...

[a2:a35] = [a2:a35*-1^(a2:a350)]

hth,
hector.




--

Dave Peterson

Thanks Dave,

It works like a charm! I don't have the slightest about the code, so I have
to store it in my "Tool Box" and just know that if I set it up right, I can
use it any time I face the same situation.


"Dave Peterson" wrote:

I'd do something like:

Option Explicit
Sub testme01()

Dim myCell As Range
Dim Var1 As Long

Var1 = 30
With ActiveSheet
Set myCell = .Cells.SpecialCells(xlCellTypeLastCell).Offset(1, 1)
myCell.Value = -1
myCell.Copy
.Range("f4:F" & Var1).PasteSpecial _
operation:=xlPasteSpecialOperationMultiply
myCell.ClearContents
End With
End Sub

This is the same thing as putting -1 in an empty cell and then edit|copy that
cell.

Then select the range to adjust
Edit|paste special|multiply
and clearing that helper cell.

Billyruben wrote:

Hola Hector,

What is wrong with the following:

Var1 = 30

[F4:F&Var1] = [F4:F&Var1*-1]

Note1: all values are positive
Note2: using F30 instead of F&Var1 works, but the column list will always be
different. (Yes, the actual variable is "Dim"ed and uses a routine to find
the last row.)

Question: what is wrong with the syntax? What is the proper way of
combining F with Var1? F&Var1 does not work.

Saludos

"Héctor Miguel" wrote:

hi, !

How do we convert positive numbers into negative ones under one column?

do you have any mixture of positives and negatives in "the range" ?
if so, and you want negatives "as is" and positives into negatives...
pretending "the range" in [A2:A35] -???-

try from vba-editor immediate window pane
(copy/paste or type) the following and press enter...

[a2:a35] = [a2:a35*-1^(a2:a350)]

hth,
hector.




--

Dave Peterson

I think doing it manually is much quicker than finding the macro, installing it,
modifying it for the correct range, and then running it.

Billyruben wrote:

Thanks Dave,

It works like a charm! I don't have the slightest about the code, so I have
to store it in my "Tool Box" and just know that if I set it up right, I can
use it any time I face the same situation.

"Dave Peterson" wrote:

I'd do something like:

Option Explicit
Sub testme01()

Dim myCell As Range
Dim Var1 As Long

Var1 = 30
With ActiveSheet
Set myCell = .Cells.SpecialCells(xlCellTypeLastCell).Offset(1, 1)
myCell.Value = -1
myCell.Copy
.Range("f4:F" & Var1).PasteSpecial _
operation:=xlPasteSpecialOperationMultiply
myCell.ClearContents
End With
End Sub

This is the same thing as putting -1 in an empty cell and then edit|copy that
cell.

Then select the range to adjust
Edit|paste special|multiply
and clearing that helper cell.

Billyruben wrote:

Hola Hector,

What is wrong with the following:

Var1 = 30

[F4:F&Var1] = [F4:F&Var1*-1]

Note1: all values are positive
Note2: using F30 instead of F&Var1 works, but the column list will always be
different. (Yes, the actual variable is "Dim"ed and uses a routine to find
the last row.)

Question: what is wrong with the syntax? What is the proper way of
combining F with Var1? F&Var1 does not work.

Saludos

"Héctor Miguel" wrote:

hi, !

How do we convert positive numbers into negative ones under one column?

do you have any mixture of positives and negatives in "the range" ?
if so, and you want negatives "as is" and positives into negatives...
pretending "the range" in [A2:A35] -???-

try from vba-editor immediate window pane
(copy/paste or type) the following and press enter...

[a2:a35] = [a2:a35*-1^(a2:a350)]

hth,
hector.




--

Dave Peterson


--

Dave Peterson