I am running excel 2003. In general terms, I have a cell that has a value of
123 in it. I want to be able to copy another cell that has a value of 3 in
it and do some sort of "Paste Special-Formula-Add" so that the cell will now
show "=123+3" in it. if the cell already has =123 in it, then I can get it
to work, but it only has 123 in it so I end up with a new cell that has 126
in it. The problem is that I need to do this with thousands of cells and I
need to be able to do this so that I have an audit trail and that I know that
the original value was 123 and that I added 3 to it. Can anybody think of a
way that I can get this to work? I need to be able to automatically insert
an equal sign in every cell or have my paste funtion do this for me. Any
thoughts? I've tried everything i can think, except for a special macro.