Insert a number a number in column
IF the value is 100000 lower than it should be, then you can do it in
one step - put 100000 in one blank cell, copy it, then select the other
cells as a block - now, edit paste special, use the ADD option to add
this value.
|