Converting positive numbers to negative numbers

T

Treg67

How can I convert positive numbers to negative numbers without retyping each
entry, thanks
 
A

Ardus Petus

Enter -1 in an empty cell.
Edit>Copy.
Select your positive numbers
Edit>Paste special, check Multiply option

HTH
 
D

Dav

if the list is just postive numbers, type -1 in a cell and select an
copy it, then select the positive numbers and past special, multipy.

Regards

Da
 
S

SteveG

Treg67,

Type -1 in a cell. Copy that. Select the numbers you want to conver
to negative. Paste Special and select Multiply.

HTH,

Stev
 
B

Bondi

Treg67 said:
How can I convert positive numbers to negative numbers without retyping each
entry, thanks
Click to expand...

Hi,

One way would be to type -1 (minus one) in a cell then -> Edit -> Copy.

Select the range of values you want to convert and chose -> Edit ->
Paste Special and here chose under under the Operations section ->
Multiply and click OK

Regards,
Bondi
 
Top