How to stop Excel from automatically splitting a CSV

One of the annoying features added to Excel is that when you open a file with csv extension it automatically parses the file on the "," and butchers your file. This is annoying if the file uses another character to split or contains German numbers which use a comma for the decimal etc. So how do you fix this? 1) Open Excel (dont double click on the CSV) 2) Go to "Data" -> "Get External Data from Text" 3) Select the CSV file 4) Click "Import" 5) Go through the wizard and specify the delimiter and that all fields are text not numebrs etc 6) You are done.