"Lori" wrote:
I need to add 3 to each number. Ex. 12.46 needs to change to 15.46.
This can be done in the same column

Put 3 into some cell and copy that cell. Then select the range of numbers
to be incremented and do paste-special-value-add. For example, right click,
click Paste Special Value, select Add and click OK. Then you delete the
value 3 in the helper cell.


----- original message -----

"Lori" wrote in message
...
Hi All,

I know this is probably a very simple function, but I can't for the life
of
me make this work!!! I have a column with all different numbers. I need to
add 3 to each number. Ex. 12.46 needs to change to 15.46. This can be done
in
the same column or a different column. Doesn't matter. I just need to add
3
to each number in the column. Right now I'm typing them in

Thanks in advance!

Lori