Flipping numeric values
 

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

Flipping numeric values
 

Hi,

Am Sat, 13 Dec 2014 15:11:38 -0500 schrieb :

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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Flipping numeric values
 

On Sat, 13 Dec 2014 21:22:25 +0100, Claus Busch
wrote:

Hi,

Am Sat, 13 Dec 2014 15:11:38 -0500 schrieb :

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

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

Flipping numeric values
 

Hi,

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

Paste = Paste Special = Multiply


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional