+ Reply to Thread
Results 1 to 3 of 3

Stop Text Number formatting as Scientific

  1. #1
    Registered User
    Join Date
    09-25-2007
    Posts
    4

    Stop Text Number formatting as Scientific

    I have a file spooling from Oracle to a format that opens in Excel. Some part numbers are coming in as numbers in advance and then formatting as scientific notation. That's bad enought, but when I format them as text, they stay in that format even theough the cell contents are correct. I can't control the format from the Oracle side, but was wondering what I could do with Excel. I thought maybe there was a way to set the default to text or something in advance, or maybe to develop a VBA routine. In the meantime, I may have to tell the user to do something. Does anyone have any suggestions?

  2. #2
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517
    I know you say you can't control the format from the oracle side but...
    If you can get oracle to preceed the number with a ' then EXCEL will interpret it as text.

    Is oracle creating a text file (.csv or .txt or similar) that is then being interpreted by EXCEL?

  3. #3
    Registered User
    Join Date
    09-25-2007
    Posts
    4
    i actually did get them to format with the ' apostrophe. Interestingly, though, you can see the apostrophe, while normally you can't. I may just have to put up with that, though. I ended up creating a view in Oracle which appended an apostrophe to those fields, then queried the view instead of the underlying table. Thank you for your efforts.

+ 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