How to change a column number from positibe to negative

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working with longitude data which require negative values . Some of
these imported values are positive so I have to change them to negative
values without changing the current negative values. Working with Access and
Excel 2007
 
say you have a column with a mixture of positive and negative numbers and you
want to change only some of the positive numbers into negative numbers.


In an unused cell enter -1 and copy this cell. Then in the column, select
only those cells you want to reverse. Then paste/specisl with multiply
checked.
 
If you want to change ALL the positive numbers into negative, then in B1 enter:
=-ABS(A1)
and copy down
 
Back
Top