+ Reply to Thread
Results 1 to 8 of 8

Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    What is shown below is just a portion of a large.... very large table I was trying to copy and paste into Excel. Look on the left side below for the example of what I got after my paste. The area to the right shows what a few of the characters looked like in their original format (I used the dots to help with positioning in this post - apparently, what you type is not what you get so I added the dots)

    So QUESTION - How is this "pre-corrected" so I don't have to manually correct each item, which by the way, I still don't know how to do, without turning each fraction into a "text" which then defeats the purpose I have in the first place!

    Thanks!!

    Jan-00 .........................1/8000
    Jan-00 Jan-00...........................1/6400 1/6000
    Jan-00..........................1/5000
    Jan-00
    Jan-00 Jan-00
    Jan-00
    Jan-00
    1/1600 1/1500
    1/1250
    1/1000
    1/800 1/750
    1/640
    1/500

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    Format the cells as Text beforehand
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    07-10-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    Thank you for your reply.... but your suggestion (which I had already tried, but did try again) did not work..... 1/8000 of a second indicated in the field as 1/8000 still showed up in my spreadsheet as Jan-00

  4. #4
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    or go to excel options /advanced /check transition formula entry
    paste data into excel it will put 1/8000 in as =1/8000
    go back to options and uncheck transition formula entry

    then custom format the cells # ???/????
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  5. #5
    Registered User
    Join Date
    07-10-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    I am sorry............ that still did not work..... I still got the Jan-00 dates

    The info is coming from this location http://www.scantips.com/lights/fstop.html

    There is a lot of "merges" on the page, so I was trying to copy "from below the column titles" and only the first three sections, of four.

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    Format the entire worksheet as text.

    Copy the data and paste to Excel. It the little dropdown that appears adjacent to the paste area, select Match Destination Formatting.

    A portion of what I just did:

    Please Login or Register  to view this content.
    No dates there.

  7. #7
    Registered User
    Join Date
    07-10-2013
    Location
    Charlotte, NC
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    hey hey ...Thank you! So .... these numbers are now "text" .... I am not sure that is an issue for me... as I don't plan to exercise any numeric math functions.... however.... is there a way to convert the page back to a general numbering format and will that rid the page of those annoying little green warning triangles??
    thanks again........ as I had not seen that little drop down box in the low right corner before..

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy and Paste mixed numbers such as 1/8000 of a second are recognized as dates

    well transition formula entry ticked certainly works
    Attached Files Attached Files

+ 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