There have been any number of CSV related threads.

Here is an old one which contains a UDF which handles all of Excels idiosyncracies:
http://www.kixtart.org/ubbthreads/showflat.php?Cat=&Board=UBB1&Number=35833