Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent negative numbers from changing to positive in calculation | New Users to Excel | |||
Changing positive values to negative | New Users to Excel | |||
Changing formuals from Positive to negative | Excel Discussion (Misc queries) | |||
Changing Positive to Negative | Excel Worksheet Functions | |||
simple query changing set of numbers from positive to negative | Excel Discussion (Misc queries) |