Re: But if you were regularly importing CSV ...
"But if you were regularly importing CSV into a spreadsheet, wouldn't you write a macro that set the column types first, then imported it ?"
No, I would continue to expect the spreadsheet to treat my data as data and not pre-mangle it into corrupted data. If some of the data required cell formatting I would do that, as and when I wanted.
Bloody stupid marketing departments !!!!!!!!!