Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Convert Downloaded Web Page Numbers Seen As Text To Numbers

  1. #1
    Join Date
    13th October 2004
    Posts
    53

    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. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,299

    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 at 19:52.

  3. #3
    Join Date
    13th October 2004
    Posts
    53

    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

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,299

    Re: Converting Text To Values

    Sorry for my bad English.

    Hold down Alt key while pressing 160.

    Does it make sense?

  5. #5
    Join Date
    13th October 2004
    Posts
    53

    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

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,707

    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!

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Convert Numbers Seen As Text To True Numbers
    By Moradin in forum EXCEL HELP
    Replies: 4
    Last Post: November 21st, 2007, 08:16
  2. Convert Numbers as Text To True Numbers
    By Mavyak in forum EXCEL HELP
    Replies: 3
    Last Post: September 29th, 2007, 11:02
  3. Convert Numbers, Seen as Text, To True Numbers
    By frontliner in forum EXCEL HELP
    Replies: 5
    Last Post: November 27th, 2006, 09:54
  4. Convert numbers to text
    By bmered in forum EXCEL HELP
    Replies: 2
    Last Post: January 19th, 2006, 02:25

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
  •  
porno