I cannot find any way to get Excel to ask me for the format of aCSV file, short of changing the file extension!
If I import a text file, Excel will ask me for the formats of the columns, but CSV files it automatically assumes a format for each field. Given that I have got fields which may have a leading zero and may be numeric, I get extremely frustrated that Excel lops the leading zero off every time. Even worse is when it decides that my numeric reference is a big number and displays it as an exponential. Even even worse is when I have some fields which are <numeric>E<number> as a (perfectly valid) reference ID. Excel assumes that those are exponentials and converts the E<number> into a perfectly spurious set of additional zeros.
Added to which, if you import a file and change something else and save it, Excel then saves what is displayed, rather than what the underlying data is. So if a long number was displayed as an exponential, it will be saved as an exponential, thus losing any richness in the data!
So why does Excel do that? Why can't I specify the format of CSV files? And how can I make it do it (short of changing the file extension or unlinking the CSV extension from Excel)