Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative
Hi,
If I want to change an entire Column to negative figures. I remember I've seen someone just multiplying that by -1 and copy and paste. I dont remember the ins and outs. Do you know a quick way. EG 1 5 6 And I want now -1 -5 -6 -- Many thanks for your help, Jose |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative
enter -1 in an empty cell.
Copy this cell Highlight your list Right-click/paste special/multiply "Jose" wrote: Hi, If I want to change an entire Column to negative figures. I remember I've seen someone just multiplying that by -1 and copy and paste. I dont remember the ins and outs. Do you know a quick way. EG 1 5 6 And I want now -1 -5 -6 -- Many thanks for your help, Jose |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative
Jose,
You are correct, a simple multiply by -1 will return the negative values. You can do this in an adjacent cell and copy and Paste the value. Copy... Right ClickPaste SpecialValues -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Jose" wrote: Hi, If I want to change an entire Column to negative figures. I remember I've seen someone just multiplying that by -1 and copy and paste. I dont remember the ins and outs. Do you know a quick way. EG 1 5 6 And I want now -1 -5 -6 -- Many thanks for your help, Jose |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative
Hi
- put -1 in an empty cell - copy this cell - select your negative numbers - use 'Edit - Paste Special - Multiply' -- Many thanks for your help, Jose "Thomas [PBD]" wrote: Jose, You are correct, a simple multiply by -1 will return the negative values. You can do this in an adjacent cell and copy and Paste the value. Copy... Right ClickPaste SpecialValues -- --Thomas [PBD] Working hard to make working easy. Answered your question? Click ''Yes'' below. "Jose" wrote: Hi, If I want to change an entire Column to negative figures. I remember I've seen someone just multiplying that by -1 and copy and paste. I dont remember the ins and outs. Do you know a quick way. EG 1 5 6 And I want now -1 -5 -6 -- Many thanks for your help, Jose |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative
The quickest way I know is enter -1 in an unused cell.
Copy that cell then select the range to change and Paste SpecialMultiplyOKEsc Much easier than creating formulas which you have to change to values. Gord Dibben MS Excel MVP On Fri, 3 Oct 2008 08:05:01 -0700, Jose wrote: Hi, If I want to change an entire Column to negative figures. I remember I've seen someone just multiplying that by -1 and copy and paste. I dont remember the ins and outs. Do you know a quick way. EG 1 5 6 And I want now -1 -5 -6 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing color of negative bar when using Invert if negative | Charts and Charting in Excel | |||
I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions |