| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to add one number to a range of numbers
If i have a range of numbers in one column, how do i go about adding a single
number to this entire range? for example if i have 345 654 143 7553 45465 how do i add .009 to each of these numbers in the range? |
|
#2
|
|||
|
|||
|
Hi,
This is easy. Put 0.009 into a blank cell and copy it. Now select the range that contains the values you want to add this value to, goto Edit- PasteSpecial-Add (alt+E, S, Alt+D), and voila! Hth, Oli -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| How do I add a range of numbers to sum a specific total? | Excel Worksheet Functions | |||
| I Need a Formula to Auto-fill Phone Numbers in a Range | Excel Worksheet Functions | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
