Number data in 10 columns and 25 rows pasted from other source is text


  1. Posts : 394
    Home Premium 64 bit
       #1

    Number data in 10 columns and 25 rows pasted from other source is text


    ..... and I want to convert the lot to 2 decimal place numbers.

    Excel has several methods, but none seem to work for conversion in bulk. Working on futher cells from a suitably formatted one does not work.

    Is the only way to solve my problem to manually enter the numbers elsewhere, clear the original cells, and then cut and paste back to the original cells?

    Help please!
      My Computer


  2. Posts : 1,030
    Linux Mint / XP / Win7 Home, Pro, Ultimate / Win8.1 / Win10
       #2

    Need more info about the source text file. When opened in Word and Show All (the paragraph mark) is enabled, what does the text file look like?

    See this thread from a couple years ago and see if it gives you any ideas:

    Please Help - Data in Text File to be arranged in Excel in a specific

    Regards,
    GEWB
      My Computer


  3. Posts : 394
    Home Premium 64 bit
    Thread Starter
       #3

    I'll have to read the link later, but thanks.
    :)
    Data was acquired from numbeo.com for several currencies as here. only cols 1&2 being relevant. The intention was to convert to GBP.
      My Computer


  4. Posts : 394
    Home Premium 64 bit
    Thread Starter
       #4

    Hi Guys! I've found a way to do it.

    I re-saved the Excel file as a PDF, selected the data I wanted to convert from text to numbers and copied it to thr clipboard. Then in the Excel sheet I pasted the clipboard contents over the problem text. ISNUMBER function proved all items are now numbers.
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 04:23.
Find Us