• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

problem saving excel as csv file - leading zeros dissappear in a cell with numbers

W

wnorrick

Member
I have an excel file that has many columns. I have to upload charges to our software program using a csv file. The file uses the apartment number as one of the fields to match when it records my charges. Many apartment numbers have a leading zero and when I save the file as csv the zeros go away. I have to have them in place for the records to match. This is just for apartment numbers 100 to 999. Could someone help me with the best way to get the zeros back and for them to stay? Would some vba code work? We have formatted the column as text, manually added the zeros in and the software does not recognize it as a valid csv file now. Also when we save the csv file, close it and then reopen the zeros are gone.
Any suggestions on how to get the zeros back, format the cells for they are recognized as csv and get a successful upload? This is a new problem as the apartment number format in the software program recently changed.
Any help is appreciated.
 
Thank you Bob. Something so simple was causing me a lot of frustation. This worked. I really appreciate your help. Wanda
 
You must log in or register to reply here.
Back
Top