Flipping numeric values

[infodex]

How do I flip a string of positive numbers to negative? I'm not
looking for a script, just some way to select the range of numbers and
flip them.

Dick Evans

 

[Claus Busch]

Hi,

Am Sat, 13 Dec 2014 15:11:38 -0500 schrieb (e-mail address removed):

How do I flip a string of positive numbers to negative? I'm not
looking for a script, just some way to select the range of numbers and
flip them.

write -1 in a empty cell and copy this cell. Select your numbers and
paste special => Multiply


Regards
Claus B.

 

[infodex]

Hi,

Am Sat, 13 Dec 2014 15:11:38 -0500 schrieb (e-mail address removed):


write -1 in a empty cell and copy this cell. Select your numbers and
paste special => Multiply

I don't see a Multiply option. I'm using Excel 2010.

 

[Claus Busch]

Hi,

I don't see a Multiply option. I'm using Excel 2010.

Paste => Paste Special => Multiply


Regards
Claus B.