Converting positive numbers to negative numbers

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

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

Regards

Dav

Treg67,

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

HTH,

Steve

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

HTH
--
AP

"Treg67" <[email protected]> a écrit dans le message de news:
[email protected]...
> How can I convert positive numbers to negative numbers without retyping
> each
> entry, thanks

Treg67 wrote:
> 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