--Enter 1 in a cell and copy the cell
--Keeping the copy select the column and press F5
--Select FormulasNumbers (uncheck other options under formulas) and hit OK.
This will select all numbers
--Right clickPasteSpecialAddHit OK

If this post helps click Yes
---------------
Jacob Skaria


" wrote:

can I +1 to a col, but if there is not an existing value,
ie its blank or - is present nothing will be added