+ Reply to Thread
Results 1 to 2 of 2

Comma seperated list of numbers

  1. #1
    Registered User
    Join Date
    07-24-2009
    Location
    widnes, england
    MS-Off Ver
    Excel 2003
    Posts
    1

    Comma seperated list of numbers

    Hi all

    I'm generating an excel report on the fly with data coming from an oracle database. One of the fields in the database is a comma seperated list of numbers. When I try and view this in Excel it is treating it as a number field and doesn't display properly. For example, it displays the first five numbers correctly and then converts everything else to 0. I presume its because its treating it as a number field. When I concatenate a letter on the end it displays fine but I can't do this as this data is being used by another system which requires the field as it is in the database. Does anyone know how I can resolve this. I've tried changing the format of the cell to text but it just displays the number to the power of 74 (1.4214314415916E+74). Heres the list that is being generated by excel.

    142,143,144,159,160,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Comma seperated list of numbers

    By what means are you retrieving values from Oracle into your file ?

    You're approach of using Text format prior to insertion is correct but depending on how exactly you're inserting the values into XL it will as you know be "helpful" and coerce "numbers stored as text" to numbers... could you perhaps alter your SQL query and append the string so as to precede the numerics with ' character ?

+ 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