changing numbers from positive to negative in a sheet
 

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.

changing numbers from positive to negative in a sheet
 

Multiply by -1

Enter in any empty cell: -1
Copy that cell
Select the range, right-click paste special check "Multiply" OK
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,300 Files:361 Subscribers:57
xdemechanik
---
"John A." wrote:
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.

changing numbers from positive to negative in a sheet
 

In an empty cell, enter the number -1
EditCopy
Select your numbers to be corrected
EditPaste Special, check Multiply

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"John A." <John wrote in message ...
|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.

changing numbers from positive to negative in a sheet
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"John A." <John wrote in message
...
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.