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.