Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Feb 2003
    Location
    Bayonne, New Jersey, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel not changing imported text to number

    I exported information from the company customer database to excel, the information came over as text. I've tried to convert the text to numbers but it's not working. Can anyone help?
    Attached Files Attached Files

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel not changing imported text to number

    Type this formula into cell B2 : =VALUE(A2). It converts text to a value!
    Regards,
    Rudi

  3. #3
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel not changing imported text to number

    1. <LI>Type the number 1 on a new workbook & copy this number to the clipboard (select the cell and press Control +C).
      <LI>Go to the sheet that you imported the data into and press F5 (displays the Go to dialog).
      <LI>Click Special then check Constants and click OK. This will select the text numbers.
      <LI>With the data selected go to Edit>Paste special then check the Multiply option and click OK.

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Excel not changing imported text to number

    Yeah...great suggestion! I often forget about Paste Multiply!!!
    Cheers
    Regards,
    Rudi

  5. #5
    New Lounger
    Join Date
    Feb 2003
    Location
    Bayonne, New Jersey, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel not changing imported text to number

    Thanks Tony, you're the BEST! <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

  6. #6
    New Lounger
    Join Date
    Feb 2003
    Location
    Bayonne, New Jersey, USA
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel not changing imported text to number

    Thank you

  7. #7
    2 Star Lounger
    Join Date
    Jun 2001
    Location
    Quakers Hill, NSW, Australia
    Posts
    153
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel not changing imported text to number

    Hi,

    This can also be solved with ASAP Utilities (an Excel Add-in - free!!)
    Also has another 300+ options too!

    Neville

Posting Permissions

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