Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Preventing Scientific Data Interpretation

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    When opening a text file containing security IDs(mixture of numbers and characters), any security ID containing a "E" in the 8th position, followed by numbers, is interpreted as scientific notation. This goes further than cell formatting, the cell data has been altered. I have tried pre-setting the cell format to text prior to getting the external data, but no luck. BTW: MS Word opens this file just fine.

    Any ideas?

    - Audri

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    You might want to try using the following formula to convert the number into text:

    =text(A1,"0")

    HTH

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If that does not work, set it up as a string with an apostrophe in front of the first character. Such as AABBCCDE4524
    Throw it into a string not a variant like this "'AABBCCDE4524"
    That should bully Excel into taking it as a text string.
    Hope It Works!
    Tom

  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Audri


    Try Importing the text file via Data>Get external data>Import text file. The last step of this Wizard allows you to easily nominate the Column format to be used.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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