Paste Formula

  • Thread starter Thread starter HZH
  • Start date Start date
H

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.
 
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.
Click to expand...


Go to cell location, highlight cell content UP in the 'formula bar'
area, NOT in the cell itself.
 
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.
 
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.
 
Back
Top