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
