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

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

HTH
--
AP

"Treg67" <(E-Mail Removed)> a écrit dans le message de news:
CA32FB53-8FDF-4E90-8E10-(E-Mail Removed)...
> 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 an
copy it, then select the positive numbers and past special, multipy.

Regards

Da

--
Da
-----------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...fo&userid=2710
View this thread: http://www.excelforum.com/showthread.php?threadid=56208

Treg67,

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

HTH,

Stev

--
Steve
-----------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...nfo&userid=757
View this thread: http://www.excelforum.com/showthread.php?threadid=56208

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