Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2007

    Question Unanswered: CSV Files and Numbers Stored as Text

    I seem to be having some issues with saving CSV files and then reopening them. Can someone or many of you help out?

    I have file I saved as text. Some of the data has leading 0's that need to be stored as a csv file. I change the format to text the first time I create the file and save it as a csv, it uploads through our system fine. When I open the file to make adjustments it removes all of the leading 0's and changes the format to a number.

    Is there something I am missing some place? I thought when I change the format it stays.

    Thanks in advance for any help given.

  2. #2
    Join Date
    Dec 2003
    Ottawa, Canada

    Disappearing zeros


    When you create a CSV file it is usually handled by a central database or ERP system not reopoened with Excel. If you open your CSV file with Notepad you will see that your zeros are there.

    So saving an Excel fie as CSV is a final transaction because no format are kept.
    A piece of data is like a brick
    If you don't build anything with it
    It is just a brick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts