I need to be able to append formulas. The "copy" "paste special" "add formula" function is turning the formula from the first cell into a whole number before appending to the destination cell.

example: cell 1a contains the formula 1+1+1
cell 2a contains the formula 2+2+2

I want to move the contents of cell 1a and append them to cell 2a. Copy, paste special, add formulas, this used to result in "(1+1+1)+(2+2+2)". Now what happens is "3+(2+2+2)". Cell 1a converts to a whole number.

I need the integrity of the formulas to be visible after combining the cells.