+ Reply to Thread
Results 1 to 2 of 2

Data corrupted during pasting

  1. #1
    Registered User
    Join Date
    01-05-2011
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    1

    Data corrupted during pasting

    When I paste into Excel 2008 data copied from a table in an HTML page, Excel corrupts the data by interpreting it: for instance, it arbitrarily replaces "12-34" by "Dec-34". If I change the cell format to text, it replaces it by "12754", the value for December 1st 1934!
    I tried setting the cell format to text before pasting, but this is overridden by the paste operation. If I use Paste Special using text format, I do get "12-34" as wanted but I also get all the rest of the row in the same cell, as Excel no longer recognises the separators! How can I tell it to stop try and be clever and just copy the text as it reads it?

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Data corrupted during pasting

    I'm not a mac user but you could try pasting the data into a text file and then importing it into Excel. On the pc version this would invoke the Text Import Wizard where you can specify the format of columns etc and prevent Excel from being 'clever' and parsing values to dates etc.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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