Converting positive numbers to negative numbers

[Guest]

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

 

[Ardus Petus]

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

HTH

 

[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

 

[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

 

[Bondi]

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

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