+ Reply to Thread
Results 1 to 1 of 1

Using clipboard; when pasting, the cells formats are changed.

  1. #1
    Registered User
    Join Date
    06-03-2017
    Location
    US
    MS-Off Ver
    2016
    Posts
    1

    Using clipboard; when pasting, the cells formats are changed.

    I've been using the clipboard on excel for about the past 6 years every two weeks. Just recently, something has been going wrong and I am not able to use the clipboard the same way anymore and now it is very time consuming. w

    I change a few things but to keep it simple this is an example of what's going on.
    http://i.imgur.com/TbC66fO.jpg

    As you can see, I update the dates and I input new data. I copy the dates so that when I have to update another customers spreadsheet I already have the dates so I can just install it. This is what it's supposed to look like when I paste all of the stuff from the clipboard. The problem is that lately the format of pasting the cells are coming off as very wrong and I do not know why.

    When I paste from the clipboard, this is what it's doing now.
    http://i.imgur.com/JDilBCD.jpg

    As you can see, the H column is wider making me end up printing a second page, the date changes from 17 to 2017, and the dates also change format. When before everything was pasting exactly as is in the clipboard. I believe this must be a problem with excel somewhere because it does the same on a different computer that i had tried. Also, paste special doesn't always work.

    If you guys have any solutions, ideas, let me know because I'm really stuck here. I know I can do paste special but I paste many times and its just more efficient to have it the way it was. Also, let me know how it works for you guys. Maybe I just have to uninstall everything if it's working fine on your end.right now I have office 2016.

    edit: I just want to paste and it'll look just like what is being pasted instead of coming out like this;
    http://i.imgur.com/E5Js2ma.jpg
    Last edited by Ps08; 06-03-2017 at 03:59 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pasting values from the clipboard
    By orangebloss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-08-2016, 11:00 AM
  2. [SOLVED] Pasting clipboard contents using VBA
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-14-2015, 09:41 PM
  3. [SOLVED] Pasting range from clipboard
    By mattmania in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2013, 09:20 AM
  4. Date Formats get changed
    By bipin_chandarana in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 01-21-2012, 11:40 AM
  5. [SOLVED] Why are my cells locking after pasting from office clipboard?
    By Wilesworld in forum Excel General
    Replies: 0
    Last Post: 08-11-2006, 03:40 PM
  6. [SOLVED] Pasting multiple cells using Office Clipboard
    By doughboy in forum Excel General
    Replies: 2
    Last Post: 07-22-2005, 02:05 AM
  7. Pasting from Excel Clipboard with VBA Macro
    By ExcelPeter218 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-09-2005, 11:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1