Saving Microsoft Excel CSV format with leading zeros

By Tzapha ·
Tags: Microsoft
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
Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums