Announcement

Collapse
No announcement yet.

Convert Downloaded Web Page Numbers Seen As Text To Numbers

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Convert Downloaded Web Page Numbers Seen As Text To Numbers



    Hi al

    Please see attached file. A colleague is downloading rows of data from a website which contains a number field Excel is currently treating as Text after being pasted in.

    My spreadsheet includes just a sample of the many rows of data however as you can see the VALUE function refuses to convert these text values to numbers.

    Can anyone offer any advice on how these might be converted and why the VALUE function refuses to work in this case?

    TIA,

    Steve Stewart
    Attached Files

  • #2
    Re: Converting Text To Values

    Hi,

    Select the range > Hit Ctrl + H >

    Find what: Hit Alt+160

    and click on Replace All.

    HTH
    Last edited by Krishnakumar; January 16th, 2008, 20:52.
    Kris

    ExcelFox

    Comment


    • #3
      Re: Converting Text To Values

      Hi Kris

      Thanks for the swift response and perhaps I'm being a bit dim but selecing my range of values to convert followed by your suggestion of what to replace returns an error stating Excel 'couldn't find any data to relpace'.

      Could you please elaborate?

      Thanks again,

      Steve

      Comment


      • #4
        Re: Converting Text To Values

        Sorry for my bad English.

        Hold down Alt key while pressing 160.

        Does it make sense?
        Kris

        ExcelFox

        Comment


        • #5
          Re: Converting Text To Values

          Hi Kris

          Absolutely no need to apologise for your English and thanks again for responding.

          Holding down Alt while pressing 160 enters the ' ' symbol into 'Find what' however 'Replace All' still confirms that this data cannot be found.

          Am I doing something wrong?

          Thanks,
          Steve

          Comment


          • #6


            Re: Converting Text To Values

            Select the cell and select the unseen character ONLY between ' and the 1st number, copoy with Ctrl+C. Edit>Replace Ctrl+V in the Replace what box, leave the Replace with empty and click Replace All.

            BTW, your calculations are in manual, not good!

            Comment

            Working...
            X