Ask Experts Questions for FREE Help !
Ask
    clarkcomputer's Avatar
    clarkcomputer Posts: 2, Reputation: 1
    New Member
    		  
    #1

    Jun 25, 2012, 06:18 AM
    Excel copy/paste not always working correctly
    Office 2007 on a Windows 7 PC. A user has an intermittent problem where when she copies a cell with a formula in it, clipboard picks it up as text. Typically, if one pastes a copied cell with a formula it also puts the formula in the cell. Not always with this one. Likewise the drag feature where one can grab the lower right corner of a cell and drag it down to past the contents of that cell into the cells below. Doesn't work sometimes. Similarly large numbers (13 digits) copied paste to a cell in text and are jacked up.
    We've tried closing Excel and reopening. Rebooting. Even a complete uninstall and reinstall of Office. Not helped.
    Any ideas?
    suzier's Avatar
    suzier Posts: 6, Reputation: 1
    New Member
    		  
    #2

    Jul 15, 2012, 12:49 PM
    I suspect the cells are defined as "Text". A cell defined as text will not apply any Excel's own formatting/definition and is only what is entered. If you copy a "text" cell the destination cell is "text" as well. Try redefining the source and destination cells as "general", "date", "number", etc. before using the copy/paste feature.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

If statement in excel macro not working correctly [ 1 Answers ]

I tried to insert the following code into an Excel macro If Range("m1") = "" Then MsgBox ("Number of Units is blank") End If I am doing something wrong, because I get the msgbox whether cell m1 is empty or not. Can anyone help me with the correct syntax?

Copy and paste! [ 2 Answers ]

I just recently purchased a new PC. (dell inspiron, windows vista)when I was with msn.had a different PC, I was able to copy pics, cartoons etc, and paste it into an email.I am now with verizon and am no longer able to copy pics , cartoons etc. all I get is the printed words.is there a reason for...

Copy and paste [ 1 Answers ]

If I want to copy and paste something onto an email it doesn't take it. What am I doing wrong?

Copy and paste [ 1 Answers ]

I hope someone can show me how to copy and paste a link onto my browser.I right click,it will show copy,select all in the box. What do I do next?:confused:

View more questions Search