Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Excel copy/paste not always working correctly (https://www.askmehelpdesk.com/showthread.php?t=674946)

  • Jun 25, 2012, 06:18 AM
    clarkcomputer
    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?
  • Jul 15, 2012, 12:49 PM
    suzier
    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.

  • All times are GMT -7. The time now is 07:54 AM.