Thread
:
Changing the sign of cell using a macro
View Single Post
#
5
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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 With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson