Question: how do you copy and paste a formula in excel without it changing?
Answer: Select the cell with the formula you want to copy.
Select the formula in the formula bar using the mouse, and press Ctrl + C to copy it. ... 
Press the Esc key to exit the formula bar.
Select the destination cell and press Ctl + V to paste the formula there.