After copy, go to Edit > Paste Special and select Values and that will not copy the formula across.