| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
CHANGE POSITIVES VALUES TO NEGATIVES
I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I
ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CHANGE POSITIVES VALUES TO NEGATIVES
Hi andresg1975
Enter -1 in a empty cell Copy this cell Select your data EditPaste Special Choose Multiply OK -- Regards Ron de Bruin http://www.rondebruin.nl "andresg1975" wrote in message ... I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CHANGE POSITIVES VALUES TO NEGATIVES
Thanks a lot
"Ron de Bruin" wrote: Hi andresg1975 Enter -1 in a empty cell Copy this cell Select your data EditPaste Special Choose Multiply OK -- Regards Ron de Bruin http://www.rondebruin.nl "andresg1975" wrote in message ... I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CHANGE POSITIVES VALUES TO NEGATIVES
Multiply the cells by -1.
If the range of cells is A1:A1000, then in column B, starting in B1, put =A1*-1, and fill down as appropriate. -- Brevity is the soul of wit. "andresg1975" wrote: I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
CHANGE POSITIVES VALUES TO NEGATIVES
Hi
Cut your data from your actual column, select a cell in a helper column, Paste it. Now copy your data from the helper column, select the cell in your actual colum, Paste Special - "Subtract". Jaleel "andresg1975" wrote: I NEED TO CHANGE POSITIVES VALUES TO NEGATIVE IN A LOT OF CELLS. HOW CAN I ACCOMPLISH THIS WITHOUT DOINT IT ONE BY ONE. THANKS FOR YOUR HELP. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find the largest change of values in a column | Excel Worksheet Functions | |||
| How do I change a range of values from + to -? | Excel Discussion (Misc queries) | |||
| Formulas not recalculating when values change on another sheet | Excel Worksheet Functions | |||
| Sort ignoring negatives and positives | Excel Worksheet Functions | |||
| Change all values in an excel column at once? | Excel Discussion (Misc queries) | |||
Linear Mode
