changing numbers from positive to negative in a sheet

J

John A.

I downloaded an expense spreadsheet and it shows the charges as positive and
I need to change these numbers to negative. There are up to 150 numbers in a
column so it would be great to highlight the entire column and change + to -
and - to + where appropriate. I am using Microsoft Office 2000 on this
computer. All help would be appreciated.
 
N

Niek Otten

In an empty cell, enter the number -1
Edit>Copy
Select your numbers to be corrected
Edit>Paste Special, check Multiply

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I downloaded an expense spreadsheet and it shows the charges as positive and
| I need to change these numbers to negative. There are up to 150 numbers in a
| column so it would be great to highlight the entire column and change + to -
| and - to + where appropriate. I am using Microsoft Office 2000 on this
| computer. All help would be appreciated.
 
B

Bernard Liengme

In an empty cell enter the value -1 (negative one)
Copy that cell
Select the range of numbers to be changed; use Edit | Paste Special with
Multiply checked in the box
Now you can delete the cell with -1
best wishes
 

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

Change positive to negative number 4
Subtracting positive amts from negative and positive from positive 3
subtract a positive from a negative 7
column of negative numbers into positive numbers 2
CONDITIONAL FORMATTING & NEGATIVE VALUES 1
How to change numbers from positive to negative. 2
Negative Numbers in a Pivot Table 1
I have a column of 50 numbers 5

Top