View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] infodex@mindspring.com is offline
external usenet poster
 
Posts: 30
Default 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.