This isn't a VBA question per say, I know how to change this in VBA but even that is not enough.

In Excel we know that if you enter only numbers, the cell automatically gets formatted for numbers. The problem with this is when you open a CSV file that for example has an ISBN or UPC number in a cell. A lot of these will have leading 0's 053308980628 for example.

Does anyone know an option that will make Excel Not Automatically format cells, hence removing the leading zero's?

I have checked everywhere I could think of in Excel but it refuses to comply.

Thanks all.