View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default 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.