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

    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.


  2. #2
    Join Date
    Feb 2006
    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,


Posting Permissions

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