Converting positive numbers to negative numbers
 

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

Converting positive numbers to negative numbers
 

Enter -1 in an empty cell.
EditCopy.
Select your positive numbers
EditPaste special, check Multiply option

HTH
--
AP

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

Converting positive numbers to negative numbers
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562080

Converting positive numbers to negative numbers
 

Treg67,

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

HTH,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=562080

Converting positive numbers to negative numbers
 

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