I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.

put 1 in an empty cell, then copy that cell

select the 3500 prices
Goto EditPasteSpecial and tick the Add box
Exit

Clear the cell with 1.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"R.Lee" wrote in message
...
I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one
column.

Type $1.00 on any cell, copy that cell, select all 3500 prices and use paste
special; Values and Add.

L.

"R.Lee" wrote:

I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.

Try this:

Enter the number 1 in a blank cell
<edit<copy
Select the cells to be impacted
<edit<paste special
Check: ADD
Check: Values
Click the [OK] button
Done

(Click the [ESC] button, to clear copy mode)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"R.Lee" wrote:

I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.

You are my Hero!


"Leamsi" wrote:

Type $1.00 on any cell, copy that cell, select all 3500 prices and use paste
special; Values and Add.

L.

"R.Lee" wrote:

I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.

Thanks! Your on my Christmas card list now!

"Ron Coderre" wrote:

Try this:

Enter the number 1 in a blank cell
<edit<copy
Select the cells to be impacted
<edit<paste special
Check: ADD
Check: Values
Click the [OK] button
Done

(Click the [ESC] button, to clear copy mode)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"R.Lee" wrote:

I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one column.

You are a lifesaver!
Thanks!

"Bob Phillips" wrote:

put 1 in an empty cell, then copy that cell

select the 3500 prices
Goto EditPasteSpecial and tick the Add box
Exit

Clear the cell with 1.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"R.Lee" wrote in message
...
I am trying, unsuccesfully to add $1.00 to each of 3500 prices in one
column.