Paste Formula
 

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

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

Paste Formula
 

On Tue, 7 Apr 2009 13:00:01 -0700, 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.


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

Paste Formula
 

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.
--
HZH


"UpGrade" wrote:

On Tue, 7 Apr 2009 13:00:01 -0700, 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.


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