TechRepublic|Forums|Software

Software

Question

  • Creator
    Topic
  • September 25, 2019 at 2:33 pm #2143718

    Saving Microsoft Excel CSV format with leading zeros

    by tzapha · about 5 years, 3 months ago

    Tags: 

    I need to save an excel file in CSV format to be uploaded to a 3rd party site for statistical reasons, but I get errors from the site because CSV files don’t seem to allow leading zeros to Save as a format ( I’ve read how to change the format to have leading zeros etc, it’s just when they’re saved in order upload that Excel will not save leading zeros in a CSV extension which I need for the upload. Does anyone know how to save an excel file as a CSV extension which saves leading zeros?
    required format: 0422362942
    saved CSV format 422362942

  • Creator
    Topic

You are posting a reply to: Saving Microsoft Excel CSV format with leading zeros

The posting of advertisements, profanity, or personal attacks is prohibited. Please refer to our Community FAQs for details. All submitted content is subject to our Terms of Use.

All Answers

Share your knowledge