--
Ed

Assuming you want to add 100 to a range of cells,

Put 100 in any empty cell and copy that cell

Select your range and use

Edit Paste Special Under "operation" select "add"

"Ed" wrote:


--
Ed

Put 100 in a separate cell, then copy that cell

Select the cells to add to
Menu EditPasteSpecial
Click Add
OK

Clear the cell with 100 in it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...

--
Ed

Thanks Daddylonglegs & Bob. I knew there was a way to do this. Thanks again.
--
Ed


"Bob Phillips" wrote:

Put 100 in a separate cell, then copy that cell

Select the cells to add to
Menu EditPasteSpecial
Click Add
OK

Clear the cell with 100 in it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...

--
Ed

Hi Bob & Daddylonglegs,

Thanks for the help.
--
Ed


"Bob Phillips" wrote:

Put 100 in a separate cell, then copy that cell

Select the cells to add to
Menu EditPasteSpecial
Click Add
OK

Clear the cell with 100 in it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Ed" wrote in message
...

--
Ed

On Sat, 20 Jan 2007 08:52:01 -0800, Ed wrote:

Put 100 in an unused cell, and copy it to the clipboard (cntl-C). Then,
select all the cells to which you want to add 100, and go to
EDIT Menu | Paste Special | click the ADD button under "operation" | then
click OK.

Thanks Jay for the help
--
Ed


"Jay Somerset " wrote:

On Sat, 20 Jan 2007 08:52:01 -0800, Ed wrote:

Put 100 in an unused cell, and copy it to the clipboard (cntl-C). Then,
select all the cells to which you want to add 100, and go to
EDIT Menu | Paste Special | click the ADD button under "operation" | then
click OK.

Hello ED
Many experts gave the answer for u r question from my side also same answer
but in different way may be it is useful for u in short method.

Step I : Type 100 (u r req no) in anyother cell except the region (which
no's u want to add)
Step II: Just copy the 100 (or ur req no)
Step III: select the region where u want to add
Step IV: Just right click the mouse, in that there is paste , Paste special
is available
Step V: Please select the Paste special , one more dialog box open,in that
Options select ADD button, then OK
Step VI : once u enter the OK button immediately you will get all the
numbers with add of req number like e.g 100

Thank u


--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"Ed" wrote:


--
Ed

Hi Prasadkakarla,

Thanks for the help.
--
Ed


"Prasadkakarla" wrote:

Hello ED
Many experts gave the answer for u r question from my side also same answer
but in different way may be it is useful for u in short method.

Step I : Type 100 (u r req no) in anyother cell except the region (which
no's u want to add)
Step II: Just copy the 100 (or ur req no)
Step III: select the region where u want to add
Step IV: Just right click the mouse, in that there is paste , Paste special
is available
Step V: Please select the Paste special , one more dialog box open,in that
Options select ADD button, then OK
Step VI : once u enter the OK button immediately you will get all the
numbers with add of req number like e.g 100

Thank u


--
Name : K.Prasad
Inventory Manager
CRYSTALGALLERY
DUBAI



"Ed" wrote:


--
Ed