[vegetable]

You should never double click to open a csv file in excel. You should ALWAYS import the file into excel. Set your types during import. Many of the complaints about excel's csv handling in this thread are user errors.

[Loranubi]

Not in this case. Excel makes it extra hard for you to do correctly. They encourage the wrong way.