| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to change a list of possitive numbers to negative
I often have a list of possitive numbers that I need to change to negative is
there a funtion to do this or do I have to do it all manually |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how to change a list of possitive numbers to negative
Put -1 in a cell
Copy that cell Select all the positives EditPastespecial, and select multiply OK Clear the -1 -- HTH RP (remove nothere from the email address if mailing direct) "michelle" wrote in message ... I often have a list of possitive numbers that I need to change to negative is there a funtion to do this or do I have to do it all manually |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to change validation list and print | Excel Discussion (Misc queries) | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
| change cell from negative to positive | Excel Discussion (Misc queries) | |||
| How do I filter a number list by numbers to the right of the decim | Excel Worksheet Functions | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
