| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing the sign of cell using a macro
Does anyone have a macro written that will change the sign
(from positive to negative or negative to positive) of a number in a cell in excel? Or, does MSFT already have a keyboard shortcut for this operation? Please help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the sign of cell using a macro
Jason,
Here's one that'll change the signs of all selected cells Sub ChangeSign() For Each c In Selection c.Value = -c.Value Next End Sub Dan E "Jason Knauff" wrote in message ... Does anyone have a macro written that will change the sign (from positive to negative or negative to positive) of a number in a cell in excel? Or, does MSFT already have a keyboard shortcut for this operation? Please help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the sign of cell using a macro
Shoulda mentioned,
DONT USE THIS ON CELLS CONTAINING FORMULAS Dan E "Dan E" wrote in message ... Jason, Here's one that'll change the signs of all selected cells Sub ChangeSign() For Each c In Selection c.Value = -c.Value Next End Sub Dan E "Jason Knauff" wrote in message ... Does anyone have a macro written that will change the sign (from positive to negative or negative to positive) of a number in a cell in excel? Or, does MSFT already have a keyboard shortcut for this operation? Please help. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the sign of cell using a macro
Thanx a million.
Any idea why MSFT dosen't have a keyboard shortcut for this one already? jasonK. -----Original Message----- Shoulda mentioned, DONT USE THIS ON CELLS CONTAINING FORMULAS Dan E "Dan E" wrote in message ... Jason, Here's one that'll change the signs of all selected cells Sub ChangeSign() For Each c In Selection c.Value = -c.Value Next End Sub Dan E "Jason Knauff" wrote in message ... Does anyone have a macro written that will change the sign (from positive to negative or negative to positive) of a number in a cell in excel? Or, does MSFT already have a keyboard shortcut for this operation? Please help. . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing the sign of cell using a macro
Jason,
Enter -1 in some cell. Copy that cell. Then select the cells whose signs you want to change. Then go to the Edit menu Choose Paste Special, and choose the Multiply option. -- Cordially, Chip Pearson Microsoft MVP - Excel www.cpearson.com "Jason Knauff" wrote in message ... Does anyone have a macro written that will change the sign (from positive to negative or negative to positive) of a number in a cell in excel? Or, does MSFT already have a keyboard shortcut for this operation? Please help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value Axis - How to remove percent sign without changing values? | Charts and Charting in Excel | |||
| Problem with changing cell contents with $ sign | Excel Worksheet Functions | |||
| + sign changing to - in Excel 2000???? | Excel Discussion (Misc queries) | |||
| changing sign | Excel Worksheet Functions | |||
| Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) | |||
Linear Mode
