| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Inverting sign
How do I invert (change) the sign in a column of numbers?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inverting sign
You want negatives to become positives and positives to become negatives?
Enter -1 in an empty cell. Copy that and select the column then EditPaste Special(in place)MultiplyOKEsc. Gord Dibben MS Excel MVP On Sun, 30 Sep 2007 19:25:00 -0700, Cheek wrote: How do I invert (change) the sign in a column of numbers? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inverting sign
One way:
Enter -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. In article , Cheek wrote: How do I invert (change) the sign in a column of numbers? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inverting sign
Thank you. It works.
"JE McGimpsey" wrote: One way: Enter -1 in an empty cell. Copy the cell. Select your column. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. In article , Cheek wrote: How do I invert (change) the sign in a column of numbers? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Inverting sign
Thank you. It works.
"Gord Dibben" wrote: You want negatives to become positives and positives to become negatives? Enter -1 in an empty cell. Copy that and select the column then EditPaste Special(in place)MultiplyOKEsc. Gord Dibben MS Excel MVP On Sun, 30 Sep 2007 19:25:00 -0700, Cheek wrote: How do I invert (change) the sign in a column of numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inverting data for a graph | Excel Worksheet Functions | |||
| inverting the error function | Excel Discussion (Misc queries) | |||
| inverting the y axis | Charts and Charting in Excel | |||
| Text string inverting | Excel Worksheet Functions | |||
| Inverting a data column | New Users to Excel | |||
Linear Mode
