Do not open the .csv file by double-clicking it. Instead, open Excel and use Data | Get External Data | From Text and this will automatically start the Data Import wizard. Follow through the steps, and in the third panel you can select each column in turn and specify how you want to treat the data (i.e. specify Text for that column).

Hope this helps.

Pete