+ Reply to Thread
Results 1 to 2 of 2

Exponential Number to Text

  1. #1
    Registered User
    Join Date
    11-08-2006
    Posts
    1

    Exponential Number to Text

    How do I format a cell to produce text, rather then the Exponential number for the following value:

    912828e72

    (Why? In the financial industry, there are security #'s called "cusips". An example of one of these 9 digit cusips would be "912828e72". I need to get that cusip number to stay in text format? (the "e" makes the excel cell think it's an exponential number)

    Even using the custom formats like 000000000, or #########, you get back: "9128280000000000etc..."
    I want it to read: 912828e72

    In addition, This data is copied from notepad, and pasted into excel. Pasting as "text" still doesn't work. It also prohibits the use of lead apostrophe's and Quotes. (so I can't use '912828e72, because there are thousands of lines of data.)

    I'd appreciate any help.
    Thanks, rich Hartmann

  2. #2
    Forum Contributor
    Join Date
    07-05-2006
    Location
    Canada
    MS-Off Ver
    2003, 2007
    Posts
    581
    Quote Originally Posted by RichHartmann
    How do I format a cell to produce text, rather then the Exponential number for the following value:

    912828e72

    (Why? In the financial industry, there are security #'s called "cusips". An example of one of these 9 digit cusips would be "912828e72". I need to get that cusip number to stay in text format? (the "e" makes the excel cell think it's an exponential number)

    Even using the custom formats like 000000000, or #########, you get back: "9128280000000000etc..."
    I want it to read: 912828e72

    In addition, This data is copied from notepad, and pasted into excel. Pasting as "text" still doesn't work. It also prohibits the use of lead apostrophe's and Quotes. (so I can't use '912828e72, because there are thousands of lines of data.)

    I'd appreciate any help.
    Thanks, rich Hartmann
    What exactly is the format of your data? Is it in a CSV type format (comma separated values)? If so, this is fairly easy to do. Make sure it has a .txt extension (.csv tends to import automatically, whereas I prefer to choose the features of each field). When you open it with excel, you'll be prompted for the data separator (quite often the ",", but sometimes something else). As well, you can choose the Data Type for the column. At this point, choose Text, and life should be wonderful.

    If there is only one value per row, that works too.

    If the formatting is more complex, it may still be possible. It would help if you posted a couple lines (with altered values -- given your industry) so we could provide specifics.

    HTH,

    Scott

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1