View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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