+ Reply to Thread
Results 1 to 4 of 4

Number formatting.

  1. #1
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Number formatting.

    One of my additional duties at my office is running the weekly and monthly statistics for our ticketing system and sending the information to our corporate office. The ticketing system exports the information as a CSV file and the ticket numbers originally show up like this: 2.01308E+15. When I format that colum for numbers with no decimal places the ticket number displays but the final number for each ticket is changed to a zero. So instead of 2013070910000025 I see 2013070910000020. Then I have to to to each cell and encapsulate the ticket number in quotes with an equals sign at the beginning, and change the last digit to its actual value for the correct ticket number to be displayed. Can anyone tell me if there is a better way to accomplish this? Is there a setting I need to change, or a formula I can use? Changing each cell is time consuming!

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Number formatting.

    Instead of just double-clicking the .csv file to open it in Excel, you can use the Data | From File option, and once you navigate to your file, Excel will automatically enter the Data Import Wizard, on the third panel of which you can specify for each field how you would like it to be treated - for your numbers column, make this TEXT, and that should preserve your digits.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    11-25-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Number formatting.

    That worked! Thanks for the advice!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Number formatting.

    You're welcome - thanks for feeding back.

    Pete

    P.S. If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, I would like to inform you that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formatting to make 2 digit number show up at 3 digit number.
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-18-2012, 06:58 PM
  2. Conditional Formatting quirk with Number formatting
    By ChemistB in forum Excel General
    Replies: 9
    Last Post: 07-20-2011, 08:44 AM
  3. Replies: 3
    Last Post: 02-12-2009, 01:08 PM
  4. Number Formatting
    By Cathie in forum Excel General
    Replies: 3
    Last Post: 08-02-2006, 06:50 PM
  5. formatting cell number based on previous cell number
    By Pasquini in forum Excel General
    Replies: 3
    Last Post: 06-20-2006, 01:40 AM

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