Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    20

    Unanswered: csv file dropping leading zeros

    Hello Everyone.

    I need to upload a csv file to another system however, when I save my excel spreadsheet as a csv file, it drops the leading zero. I have tried the following:

    format cells as text
    putting an apostrophe before each number

    and none of the above worked.

    Does anyone have any ideas? Unfortunately my file must be uploaded as csv.

    Thanks!

  2. #2
    Join Date
    Feb 2006
    Posts
    113
    It may be no different from what you're already experiencing, but, what about using the TEXT function to create the leading zeros?

    Such as, for 6 character entries,
    =TEXT(reference,"000000")

    regards,
    Fazza

Posting Permissions

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