| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I change a column of 500 numbers from positive to negative
I have a column of 500 numbers which are all positive. I would like to change
them to negative. Appreciate any help. Thanks. Ken |
|
#2
|
|||
|
|||
|
Hi,
In some other cell enter -1. Select and copy that cell, then select the column of numbers, right click and select 'Paste Special' (you can also access Paste Special under 'Edit' in the Toolbar), select 'Multiply' and click 'OK'. Now you can get rid of the -1 in the helper cell you created. Regards, B. R. Ramachandran I have a column of 500 numbers which are all positive. I would like to change them to negative. Appreciate any help. Thanks. Ken |
|
#3
|
|||
|
|||
|
Thank you, your suggestion worked just fine.
Ken "B. R.Ramachandran" wrote: Hi, In some other cell enter -1. Select and copy that cell, then select the column of numbers, right click and select 'Paste Special' (you can also access Paste Special under 'Edit' in the Toolbar), select 'Multiply' and click 'OK'. Now you can get rid of the -1 in the helper cell you created. Regards, B. R. Ramachandran I have a column of 500 numbers which are all positive. I would like to change them to negative. Appreciate any help. Thanks. Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| strange column to the left of my row numbers column | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Discussion (Misc queries) | |||
| I cannot get a column of numbers to sum, why? | Excel Worksheet Functions | |||
| Change the width of a single column in a column chart | Charts and Charting in Excel | |||
Hybrid Mode
