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

    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
    Location
    Ottawa, Canada
    Posts
    72

    Disappearing zeros

    Hi

    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
    www.excel-examples.com

Posting Permissions

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