+ Reply to Thread
Results 1 to 5 of 5

Long numbers not displaying properly

  1. #1
    Registered User
    Join Date
    04-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    16

    Long numbers not displaying properly

    Hi everyone, first post so I hope somebody can answer this one...

    I have a csv file where one of the fields is a long number, for example 990737587638. When I open the csv in Excel 2000 (and also in some later versions I have tried this on) the number displays as 9.90738E+11. My thoughts were that I just needed to format the sheet as text and save it somehow before opening the csv file but I can't figure out how to do it.

    What can I do to save my default spreadsheet as text so that these numbers appear as 12 digit text strings on opening or am I trying to do this the wrong way?

    Thanks in advance.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,735

    Re: Long numbers not displaying properly

    Formta the cell as number, it should display properly
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,735

    Re: Long numbers not displaying properly

    Format the cell as number, it should display properly

  4. #4
    Registered User
    Join Date
    04-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    16

    Re: Long numbers not displaying properly

    Thanks for the reply. If I open the csv file using Excel then format the cells that works OK. What I am trying to do is find a way that when I open the csv file, it opens in Excel with the field displaying the number properly.

    I was hoping there was some setting that I could change to save an Excel file as the default in the same folder as the csv files so that when I opened the csv file it was already formatted correctly and I didn't need to do the formatting every time (I have a lot of csv files).

  5. #5
    Registered User
    Join Date
    04-07-2012
    Location
    UK
    MS-Off Ver
    Excel 2000
    Posts
    16

    Re: Long numbers not displaying properly

    Hello again,

    I attached two screenshots to show what is happening here in case I hadn't described it very well. File1-Text is a typical csv file with long numbers, File1-Excel is what happens when I open it using Excel.

    Hope somebody can help with this.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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