A AB Sep 11, 2003 #1 I have a large range of figures in a column that are positive that I need to change to negative figures. Any quick way of doing this?
I have a large range of figures in a column that are positive that I need to change to negative figures. Any quick way of doing this?
L Leo Heuser Sep 11, 2003 #2 1. Enter -1 (negative one) in a cell, e.g. H34 2. Select H34 and copy it (<Ctrl>c for instance) 3. Select the range of figures. 4. Choose Edit > Paste special and choose "Multiply" OK. 5. <Esc> (to cancel the selection) -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please.
1. Enter -1 (negative one) in a cell, e.g. H34 2. Select H34 and copy it (<Ctrl>c for instance) 3. Select the range of figures. 4. Choose Edit > Paste special and choose "Multiply" OK. 5. <Esc> (to cancel the selection) -- Best Regards Leo Heuser MVP Excel Followup to newsgroup only please.
A Anon Sep 11, 2003 #3 AB said: I have a large range of figures in a column that are positive that I need to change to negative figures. Any quick way of doing this? Click to expand... Put the number -1 in a spare cell and copy it. Select your numbers and use Edit > Paste Special > Operation, multiply. (The -1 can now be deleted.)
AB said: I have a large range of figures in a column that are positive that I need to change to negative figures. Any quick way of doing this? Click to expand... Put the number -1 in a spare cell and copy it. Select your numbers and use Edit > Paste Special > Operation, multiply. (The -1 can now be deleted.)
P Paul Corrado Sep 11, 2003 #4 AB, In a blank cell place a -1 Edit\Copy that cell and then highlight the range you wish to change and Edit|Paste Special and select the multiply option. PC
AB, In a blank cell place a -1 Edit\Copy that cell and then highlight the range you wish to change and Edit|Paste Special and select the multiply option. PC
