Paste Formula

[HZH]

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.

 

[klswvu]

After hitting Paste, try hitting the Esc key then Enter

 

[UpGrade]

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.

Go to cell location, highlight cell content UP in the 'formula bar'
area, NOT in the cell itself.

 

[HZH]

It works, but not directly. Yyou have to hit enter after the copy and then go
to the paste cell and enter the + sign; it is pasted as text.

Any idea why the previous Paste Special, Formula, Add doesn't work in 2007?
It looks like the "copy" places the data on the clipboard as a sum, rather
than a formula, so the paste option can only add the sum, not the string of
numbers.

Thanks for the work-around.

 

[hdonald]

Got the same/similar problem. Excel is copying formulae as text. It used to work on this version of Excel, maybe I have inadvertently changed a setting.