View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Turn a row of numbers into negative value

Hi Folks

Am using Excel 2002.

I have a column of data like this:
5, 16, 27, 38, 39

Is it a fast and automatic way of turning all these into negative....
that reads
-5, -16, -27, -38, -39


Thanks!