reversing signs - making postive a negative number

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

Guest

I have a spreadsheet with amounts. When I import them in a program they go
in as opposite value. Such as the positive 35 goes in the program as -35 and
-35 goes in as 35. I have over 300 lines, and would like to reverse the
signs make the negative positive and positive negative.

Can this be done? Would like answer tonight if possible. Thanks to any one
in advance that can solve this. I am sure it is a simple worksheet functions
I have tried some even insert symbol which works but I can only do 1 cell at
a time.
 
Enter -1 in an empty cell.

Copy that cell.

Select all other cells and Paste Special>Multiply>OK>Esc.

Clear the -1 cell when done.


Gord Dibben Excel MVP
 
One way:

Put -1 in an empty cell. Copy the cell, select your values. Choose
Edit/Special Cells, selecting the Values and Multiply radio buttons.
 
1. Put a -1 into an open cell.
2. Copy that cell.
3. Select your data.
4. Go to Edit > Paste Special and choose "Multiply".
5. Press OK.

HTH
Jason
Atlanta, GA
 
If it's an option, after importing the data, say they are
all in A column, you could make B1: =-A1 B2: =-A2 etc

Since two negatives become a positive, -35 would become
35, and 35 would become -35

- Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Postive # converted to Negative # 7
Reverse the signs of values 6
Red cell for negative numbers in Excel 1
Subtracting positive amts from negative and positive from positive 3
How do I prefix a worksheet of numbers with a Minus (-) Sign 4
If sign of sum is negative change to positive 1
Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive) 1
making a # value positive or negative based on contents of another 3

Back
Top