| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i change all numbers in my worksheet
for example:
i have a row with 20,40,50,80,120 and i want it to be 0,20,30,60,100 (so all -20) how do i do this? |
|
#2
|
|||
|
|||
|
1. Put -20 in an open cell.
2. Copy that cell. 3. Select your range of data. 4. Go to Edit Paste Special and select "Add". 5. Press OK. HTH Jason Atlanta, GA -----Original Message----- for example: i have a row with 20,40,50,80,120 and i want it to be 0,20,30,60,100 (so all -20) how do i do this? . |
|
#3
|
|||
|
|||
|
or even
1. Put 20 in an open cell. 2. Copy that cell. 3. Select your range of data. 4. Go to Edit Paste Special and select "SUBTRACT". 5. Press OK. Cheers JulieD "Jason Morin" wrote in message ... 1. Put -20 in an open cell. 2. Copy that cell. 3. Select your range of data. 4. Go to Edit Paste Special and select "Add". 5. Press OK. HTH Jason Atlanta, GA -----Original Message----- for example: i have a row with 20,40,50,80,120 and i want it to be 0,20,30,60,100 (so all -20) how do i do this? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change format of all comments in worksheet? | Excel Discussion (Misc queries) | |||
| Numbers from seperate worksheet to common sheet | Excel Worksheet Functions | |||
| increment/populate numbers by worksheet | Excel Discussion (Misc queries) | |||
| Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) | |||
| Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Linear Mode
