Copy Data into MS-Excel

Question

Hi Everyone,

One of my application exports data into Excel format. The data in one of the column looks like '12/12/12', '12.5/13.9/12' and '12,12'. The problem I am facing is, excel coverts this data to DATE formate. and it makes '12/12/12' to '12/12/2012'. I tried to change the format of column to TEXT (right click on selected column and Format Cells... option), then it converts '12/12/2012' to '41255'.

Can someone please give me some idea to keep the format of data same in excel as it was exported (it should keep '12/12/12' as '12/12/12' not '12/12/2012' or '41255')???

Thanks