Excel - Auto Format Numbers on File Open

[Spajeoly]

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.

[DKenny]

If you are using the "Text Import Wizard", in Step 3 you can specify the column data format. Setting the fomat to Text will keep all leading zeros.

[Spajeoly]

Hmm, I guess I could do that. The only thing is that sometimes at work I trouble shoot tons of these a day. If need be I'll do that though, I would still love an option to never format cells.

High hopes for MS eh?

Thanks, Kenny.