Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
formula or vba to cut and paste | Excel Worksheet Functions | |||
Paste formula every nth row | Excel Discussion (Misc queries) | |||
formula cut and paste | Excel Worksheet Functions | |||
Paste Formula | Excel Discussion (Misc queries) |