I need the data in a cell to keep the leading 0 without adding an ‘ to the cell data.  I am uploading to a program that pulls the actual cell data, and the lack of the leading 0 or the addition of the ‘ both cause upload errors.

All the fixes I can find either only change the Cell Display while keeping the shortened number in the Cell Data (Special Formatting as Zip Code, or Custom Formatting as a N digit number large enough to show the leading 0 in Cell Display), or add an apostrophe to the Cell Data (formatting as text, or unchecking “Remove leading zeros and convert to a number” via Files> Excel Options> Data> Automatic Data Conversion). 

​I need the data in a cell to keep the leading 0 without adding an ‘ to the cell data.  I am uploading to a program that pulls the actual cell data, and the lack of the leading 0 or the addition of the ‘ both cause upload errors. All the fixes I can find either only change the Cell Display while keeping the shortened number in the Cell Data (Special Formatting as Zip Code, or Custom Formatting as a N digit number large enough to show the leading 0 in Cell Display), or add an apostrophe to the Cell Data (formatting as text, or unchecking “Remove leading zeros and convert to a number” via Files> Excel Options> Data> Automatic Data Conversion).   Read More

​