Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Text To Number Conversion (2000 sr1 sp3)

    The attached file contains a set of text numbers that was cut and pasted from an HTML Web page. I have tried everything I know of to convert them to numbers. The =Value() function returns #Value and the paste special values simply pastes the same text into the new cell! I would really appreciate some hlep here....

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Text To Number Conversion (2000 sr1 sp3)

    Hi Robbie,

    There's a blank character (ASCII 160) at the start of each cell. To delete them, select and copy the first character of any cell with a value in it, then paste the copied character into the 'Find what' portion of the Replace dialogue box and leave the 'Replace with' box empty.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Text To Number Conversion (2000 sr1 sp3)

    The cells start with a non-breaking space (character 160).
    Select one of these spaces at the beginning of a cell value and copy it to the clipboard. Cancel the cell edit.
    Select the range (A1:S19)
    Select Edit | Replace (Ctrl+H)
    Paste the non-breaking space into the Find What box; leave the Replace By box empty, and click Replace All.
    That should do it, hopefully.

  4. #4
    Lounger
    Join Date
    Nov 2001
    Location
    Carson City, Nevada, USA
    Posts
    46
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Text To Number Conversion (2000 sr1 sp3)

    Boy, you guys are fast.... The one thing I never thought to do was edit one of the cells directly!

    Thank you both very very much....

    Robbie...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •