Converting positive numbers to negative numbers

[Treg67]

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

[Dav]

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

[SteveG]

Treg67,

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

HTH,

Steve

[Ardus Petus]

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

HTH
--
AP

"Treg67" <Treg67@discussions.microsoft.com> a écrit dans le message de news:
CA32FB53-8FDF-4E90-8E10-43E8424067D5@microsoft.com...
> How can I convert positive numbers to negative numbers without retyping
> each
> entry, thanks

[Bondi]

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