Control automatic data conversion in Microsoft Excel

Microsoft has added options to change the Automatic Data Conversion in Microsoft Excel for Windows and Mac.  For example, this will allow you to control removal of leading zeros, etc. when importing data from a text file.   These settings are found under File > Options > Data > Automatic Data Conversion (Windows)  or
Excel > Preferences > Edit > Automatic Data Conversion (Mac).