Thread: Paste Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
klswvu[_2_] klswvu[_2_] is offline
external usenet poster
 
Posts: 27
Default Paste Formula

After hitting Paste, try hitting the Esc key then Enter

"HZH" wrote:

Excel 2007 - Can not use Paste Special, Formula, Add to copy and paste a
formula of added numbers (=24+32) to another Formula of added numbers
(=((24+30)+12)). It appears that Excel 2007 copies the first cell to the
Clipboard as a number (52) rather than the original formula. This worked
fine in Excel 2003.

Is there a way to accomplish this so that the string of numbers remains
intact.

--
HZH